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
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