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