Skip to Content
0
Former Member
May 02, 2012 at 08:06 PM

UFD1.Descr Field

20 Views

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