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 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
