Running it from an ODBC connection via PHP will not. The following statement will work in Access 2010 direct: select * from dummy where Replace(Replace(,' ',''),'-','') = 'ABCD1234' I need to be able to search against a string with white space and hyphen characters removed. I'm attempting to run a simple statement against an Access DB to find records.ĭata validation in the records was horrible, and I cannot sanitize it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |