Using Like SQL Command with numerec field type in Crystal Report(Resolved)

[maqmaq]

Hi
I am using the following SQL command to retrieve all the items records start with item number # 6 for the field ITEM NUMBER, the result is OK:

SELECT * FROM LIST_ITEMS WHERE LIST_ITEMS.[ITEM NUMBER]
Like '*6*' AND LIST_ITEMS.[ITEM Description] Like '**' ORDER BY
LIST_ITEMS.[ITEM NUMBER];

But when I use the following SQL for retrieving the same result in Crystal report, It does not work, like command seems will not work with numerical field type, it only accepts the equal sign:

{LIST_ITEMS.ITEM NUMBER} Like '*6*' And {LIST_ITEMS.ITEM
Description} Like "*"

Am I missing any parameters in the above code, appreciate your help