Looking_for_answers Looking_for_answers - 4 years ago 114
SQL Question

How to find values in column that have no full stops in table?

I am trying to find the values in a column that do not have any full stops.

Input:

COK0105.D.SKE
WAL1101
No value found
WAL1802.C
STR0001


Output:

STR0001
WAL1101


I have 40K records in the table and I can't keep looking for them manually.

Answer Source

Try this

SELECT * FROM table_name WHERE column_name NOT LIKE ('%.%');

it will fetch all the rows which does not contain "." anywhere in the text

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download