Home Forums SQL Server 2005 T-SQL (SS2K5) Need help in validating users input value(from Screen) RE: Need help in validating users input value(from Screen)

  • 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 ?