I have the following query which works in MS SQL Server, but I'm sure the
syntax is different for Myself. I'm sure it's in the area of the "LIKE"
clause. I don't know how to do this with Myself. Can anyone point me in
the right direction?:
SELECT LA.FirstName,LA.LastName,LA.EMailAddress, LA.UserName, U.Password
FROM LocalAdvisors LA
JOIN Users U ON U.UserName=LA.UserName
WHERE EMailAddress <> '' AND EMailAddress IS NOT NULL
AND (EMailPermission is NULL or EMailPermission=1) AND LA.LastName
LIKE '[A-E]%'
ORDER BY LastName,FirstName
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
