SQL 2000
Hi All,
I have a varchar column with descriptive data stored.
I need to pullout any record with 'aston' in it or 'martin'
Would a query like below do the trick?
Basically I need to pull out anything where aston or/and martin are present in the field. e.g. aston martin, astonmartin,aston,martin,astonmartin123 etc etc
Many thanks
Michael
Hi All,
I have a varchar column with descriptive data stored.
I need to pullout any record with 'aston' in it or 'martin'
Would a query like below do the trick?
Code:
select *
from [tablename]
where [description] like 'aston' or [description] like 'martin'
Basically I need to pull out anything where aston or/and martin are present in the field. e.g. aston martin, astonmartin,aston,martin,astonmartin123 etc etc
Many thanks
Michael