rwallacej
asked on
Check for varchar does not contains character
Hi,
I'd like a query to select rows where a field, called [Value] where it does not contain character "."
For example the table is called "tblMyTable"
Thanks in advance
I'd like a query to select rows where a field, called [Value] where it does not contain character "."
For example the table is called "tblMyTable"
Thanks in advance
try this
SELECT *
FROM tblMyTable
WHERE CHARINDEX('.' , [Value]) > 0
does not contain... so this will be true...
SELECT *
FROM tblMyTable
WHERE CHARINDEX('.' , [Value]) = 0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
excellent, thank-you
ASKER
Qlemo - thank-you for help
tigin44 - thank-you but I got an error with the code, I have used Qlemo's instead
tigin44 - thank-you but I got an error with the code, I have used Qlemo's instead
SELECT [ColumnList] FROM [tblMyTable] WHERE CHARINDEX('.',[Value]) = 0