Re: Regular Exp help

2006-09-29 Thread Philip Mather
Ravi, Knight 4 to Pawn's 5! Sorry, being serious for a minute, you'd need more info to solve this problem. Your example implies that something without a number after it still counts for a value of 1, i.e. > and 3 if I am searching for WT. Correct? What is the extent of the two letter co

Regular Exp help

2006-09-29 Thread Ravi Kumar.
Dear All, I have a table with a varchar column that stores data in this pattern: The pattern may be repeated upto 5 times in same cell, but the string will be different in each case. Hence there will not be a value like this: 1 BW - 2.5 BW - 1 WT - 1 BW - 1 ME - 1 BW - 1 ME - 1.5 SY