Converting Number to String for Linking Purposes

[arachnoid]

I am attempting to link a numeric field to a string by converting the numeric field to a string using the DIGITS function by modifying the SQL statement in my report.
The report does not bomb, but it does not return any data either.

Can this be done in Crystal? If so, how? I have attached my SQL statement below and bolded the section in question.

SELECT
F4102."IBLITM",
F0016."CYLIN", F0016."CYWTXT"
FROM
"SMPLEW01"."JDFDTAFS"."F4102" F4102 INNER JOIN "SMPLEW01"."JDFCOMFS"."F00163" F00163 ON DIGITS(F4102."IBITM&quot = F00163."C5CKEY" AND F00163."C5WAPP" = '*IMG' INNER JOIN "SMPLEW01"."JDFCOMFS"."F0016" F0016 ON F00163."C5SERK" = F0016."CYSERK"
WHERE
F4102."IBURAT" = 1 AND F4102."IBMCU" = ' 20101' AND F4102."IBLITM" = '590FR'

Thanks in Advance.

 

[synapsevampire]

That would depend on your version of Crystal, consider sharing technical information when asking for it...

The From Where and ORDER By can be modified, so you should be OK.

I'd guess that you still don't have the join right, and I'm afraid I don't know what database uses a digits function...

In SQL Server or Oracle you might use CAST or CONVERT.

-k