Need SQL Syntax

[gguerra3]

I'm trying to do a simple query on an employee table named Workforce1. I need to filter out all the records where lastname starts with an "*". I need help with the WHERE clause. This is for MS Access. Is this possible?

SELECT Workforce1.EmployeeNo, Workforce1.LastName, Workforce1.FirstName
FROM Workforce1
WHERE ??
ORDER BY Workforce1.EmployeeNo;

 

[PHV]

SELECT EmployeeNo, LastName, FirstName
FROM Workforce1
WHERE LastName LIKE '[*]*'
ORDER BY 1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gguerra3]

Worked fine , but I need the opposite.

WHERE 1st character of last name NOT equal to *

BTW, is there a reference manual for MS Access SQL (it does not seem to be compliant with other SQL's)

Thanks

 

[PHV]

WHERE LastName [!]NOT [/!]LIKE '[*]*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gguerra3]

Worked Fine! Thanks.. Again does anyone know of a good reference for MS Access SQL. The help doesnt seem to have much..

 

[ZmrAbdulla]

This has some good lessons

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.