Skip to content
Advertisement

Tag: wildcard

Wildcard for string before @ character

How would I use a wildcard to filter out any permutation of the following. There can be any number of zeros before the “@” character. Example Basically, I’m looking to wildcard any email address with only zeros before the @ character. Any help would be greatly appreciated Thank you ! Smiddy Answer T-SQL: To remove all values with only zeros

Sql string with OLEDB gives error 1004 in VBA

I would like to import a text file into excel filtering just what I want through a VBA macro. When I use LIKE operator in the sql string I get the error 1004. I have tried both * and % as wildcard and ALike instead of Like but there is no difference. test_7.txt and the macro is: Answer SQL statements

SQL exclude wildcard from WHERE

We’ve got a query on SAP which has some potential to cause problems. Somebody put the wildcard (%) into the prompt and of course everything got clogged up. Is there a way to disallow the wildcard in the WHERE, maybe with a CASE or something? The only other alternative I could come up with was to only select the top

Advertisement