| Convert CSV string of numbers [message #409895] |
Wed, 24 June 2009 06:57  |
abis123
Messages: 31
Registered: February 2007
|
Member |
|
|
I have a string of numbers in a comma separated value, is it possible to convert this to a comma separated value of integers.
I am using an IN statement (which can be seen below) and it checks to see if an integer is in a CSV, the problem is that the CSV is stored as a string. What I want to do is convert this string to a CSV of integers but this wont happen with a simple TO_NUMBER. Is there any way of achieving this? Many thanks in advance.
SQL:
WHERE 2 IN ECM \\(ECM being a CSV of number e.g. '2,4,7')
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
