sunshine737
asked on
query to select values that doesnt have "."
Hello,
I am having a field with values such as xxx.xxxx
xxx.xxxx
xxxx
xxxx
so i want to write a query that take only those values that doesnt have "."
could anyone help me in writing this query.
thanks
I am having a field with values such as xxx.xxxx
xxx.xxxx
xxxx
xxxx
so i want to write a query that take only those values that doesnt have "."
could anyone help me in writing this query.
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Select * From TableName
Where CharIndex('.', Field) = 0
Jayakul