Forums
This topic is locked
ASP SQL query problems
Posted 07 Sep 2004 22:16:45
1
has voted
07 Sep 2004 22:16:45 Greg LeBreck posted:
I have a cust number column1 which is 60136And a referece column2 number which is 1234560136
In my SQL Query how do I say select all where column1 is = to the last 5 digits of column 2.
It will always be the last 5 digits.
Thanks!
Replies
Replied 07 Sep 2004 23:56:55
07 Sep 2004 23:56:55 Rene Bandsma replied:
Just use fuctions like LEFT() MID() and RIGHT()