How do I use wildcard values in LIKE query using fieldname not string 1

[mikemackay]

hi everyone

I need to compare two fields in a LIKE query instead of a field and a string value. How do I put in wildcards in this query where start_date and end_date are field names:
'WHERE start_date LIKE end_date'. Can anyone help?
Mike

 

[sguslan]

Try

select *
from table1
where start_date like '%'+ltrim(rtrim(end_date))+'%'

or

select *
from table1
where start_date like ltrim(rtrim(end_date))+'%'

Good luck ...
Salim

 

[tlbroadbent]

Why do you need to use LIKE? Why not use start_date = end_date? Do the fields have times that you don't want to compare? Have you considered using the Convert function. It is documented in SQL BOL. See the topic "Cast and Convert." Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[mikemackay]

sguslan. Thanks very much. The code was exactly what I wanted. Thanks also for the quick response. Mike