I am converting over to mySQL from Access 2.0 and I am having a little trouble with a query. Here it is: SELECT Max(WBS) AS LastOfWBS FROM Projects Where((WBS)) Like """ & txtEntryData(0).Text & "#%"";
I am trying to get the last WBS ID starting with a particular letter the user will type in the textbox. My criteria is that it has to start with a letter and the next character is a number. There can be letters or more numbers to the right of the first number. For example: A01C or B001, but not AB01. In Access we could use the following query: SELECT DISTINCT Max([Projects].[WBS]) AS LastOfWBS FROM Projects where (Projects.WBS) Like """ & txtEntryData(0).Text & "#*""; How can I insure when using mySQL that the second character is a number?
