Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  wildcard for fields

Author  Topic  mikec Starting Member 5 Posts Posted - 2001-10-23 : 01:42:58 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'. The wildcards I use for strings don't work here.Can anyone help? Mike