Link to home
Start Free TrialLog in
Avatar of R8VI
R8VI

asked on

SQL convert Varchar to int stored prod

HI,

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

Thanks,

R8VI

ASKER CERTIFIED SOLUTION
Avatar of RiteshShah
RiteshShah
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial