UFD1.Descr Field

[Former Member]

I am trying to create a view in SQL that allows me to convert 2(UDF)  from memo fields so I can use the description in Crystal. My query looks like this.

SELECT     opor.DocNum, CONVERT(char(50), opor.U_INCOTems) AS U_incotems, ufd1.Descr, opor.DocNum AS Expr1, CONVERT(CHAR(50), opor.U_INCOLOC)

                      AS U_INCOLOC, ufd1.Descr AS Expr2

FROM         dbo.OPOR AS opor LEFT OUTER JOIN

                      dbo.UFD1 AS ufd1 ON opor.U_INCOTems = ufd1.FldValue AND ufd1.TableID = 'opor'

I am having trouble converting the second UDF so that I can det the description.

Any help would be appreciated.

Thanks

Steve

[Former Member]

HI

Whats the trouble you are facing on U_udf2...

Did u try converting to varchar instead of char?