[thelist] SQL Query

[Tab Alleman]

Stevenson N wrote:
> If i have  values 2.12.12 and 2.13.13.3
> 
> How can i differentiate in SQL the value that has two dots i.e
> 2.12.12 from the value that has three dot i.e 2.13.13.3 

Ooh ooh, I know a nifty trick:  

L1 = Len(TestDataStr)
L2 = Len(Replace(TestDataStr, '.', '')
NumberOfDots = L1 - L2

HTH, 
Tab