Hello, I want to use values from a field in a sql server table as paramters in my tsql query. The problem is that the data in the field is as follows:
1. There may be only one value, such as '6000'.
2. There may be more than one value, seperated by |, such as '6000'|'6001' This would mean all values that are equal to 6000 or 6001
3. There may be more than one value, seperated by .., such as '6000'..'7000' This would mean all values that are from 6000 through 7000
Any help is appreciated. Thank you.
View Complete Post