SQL/mSQL where (*) = something - Possible

My question is about SQL and mSQL.  I need to know if there is a SQL statement operator, suported by mSQL to define the "where" as a wild card. For Ex:

Select * From DB1
Where * Like S*

This would return all Fields of a row which contains any string starting with "S" no matter which field it is in...
Hence the Where *
Is this legal/Possible

Thanks
LVL 3
guadalupeAsked:
Who is Participating?
 
Victor SpiridonovCommented:
No , such statement doesn't exist. However you can create stored procedure, that will emulate such behaviour: loop through all the fields and check each of them for S* condition.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.