Try searching the length of the field Where LEN(todaysdate) <> 8
Zach Bowling Sr. Manager of Customer Analytics Work: 480.902.5908 Mobile: 602.391.5454 Email: [EMAIL PROTECTED] http://www.direct-alliance.com -----Original Message----- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 1:12 PM To: SQL Subject: Match Characters Is there a way to run a query and tell the query to return rows that match x characters but not have to use the exact characters to match. For example I need to see if there are any records that aren't like xx/xx/xx all the records are dates that are stored like 09/19/02 and in my query I Convert the field to a smalldatetime but this one table it keeps saying there is a syntax error converting the string to a smalldatetime. I have 4 other tables identical to this one only they are from four different locations in the world and this is the only one not working. I was thinking I should be able to do a query that says something like Select * from Table Where TodaysDate Not Like '??/??/??' I know that won't work but is there something like that? Thanks, Ben ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
