JoNTSQLSrv (8/2/2013)
Phil Parkin (8/2/2013)
I see.You can probably get quite close through the use of PATINDEX and diligent use of wildcards. Have you tried this?
PATINDEX is just retrieving the index value , but how come this will validate the user input value ? 🙁 could you please show me some related example ?
..And if the desired pattern is not found, it will return zero. That is how you test. You can apply repeated tests to look for different things in your proc, if necessary.
There are thousands, if not millions, of examples on the Internet if you take the time to search for them.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.