Link to home
Create AccountLog in
Avatar of johnkainn
johnkainn

asked on

query search string

I would like to select all rows from MyTable where MyText (column) contains @MyText parameter (for exampe 'London'). If @MyText is empty, i.e. " ", then I would to select all from the table. How is best to write this query?
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account