I have the following expression to use in a where clause

(WageConstIn => Convert.ToString(WageConstIn.SerialNo).StartsWith("28"))

It generates the following sql

SELECT * FROM WAGE_CONST_IN WHERE ( CAST(SERIALNO AS NVARCHAR2(2000)) LIKE '28%')

This does not seem to return any result. If i change the length of NVARCHAR from 2000 to 20 it then returns results. How can i change the result query from the query expression or create it in another way altogether cause the SQL I desire is as follows:

SELECT * FROM WAGE_CONST_IN WHERE ( SERIALNO LIKE '28%')

What's the database type of the SERIALNO?

Its is of type decimal.

I think you will need to use FunctionMappings here, to generate the function exactly as you want.

Here are some example threads: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=15730