Wildcards in SQL
Wildcards in SQL
(OP)
I am trying to program a routine to check for certain elements within an email address. i.e. *@mailserver.com The problem is that I can't see a way to have sql check for wildcards. Actually at this moment I am using Access to program my database. I am using some sql in my programming. Is there a way to do this? Or do I need to migrate over to SQL Server to do it? Can it even be done?
RE: Wildcards in SQL
RE: Wildcards in SQL
RE: Wildcards in SQL
RE: Wildcards in SQL
RE: Wildcards in SQL
For example:
Select * from myTable WHERE ColumnX LIKE %ABCD%
will return true if 'ABCD' was found in ColumnX.