Sql Function format

[mlazlo]

I am attempting to return data from a table filtered by a column that is of type decimal. I want to compare it to a character string. When I try to do this using the format that AcuOdbc states to use with functions I get errors.

For example:

select * from cfpsn
Where {fn CONVERT(VarChar(6),DATE_TO_SHIP)} > '123103'

This format should be correct, but it errors. Anyone know the format that AcuOdbc driver accept for the 'Convert' function?

Thanks in advance.