I have the following stored prod
GetSearch @JoinClause = N'', @WhereClause = N' (A.S LIKE ''2A%'') And (A.W Like ''%2000%'') And (A.L LIKE ''100'') ', @LD = 1
What i want to do is convert the A.S LIKE ''2A%' and A.L LIKE ''100'' to A.S >=''2A%' and
A.L <=''100' .
But i need a convert to int in there somewhere as those fields are declared as VARCHARS and i dont want to change the declaration. So how do i do this please help