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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.