Wildcard in a SELECT statement

[Neozero]

Is there a way that I can use a wildcard in my select statement that pull the first 3 digits of something? what I mean is, I want to pull everyone that has an area code of 201 from my database, but my field has all 10 digits. so for example I want do a select that pulls the persons name, and phone number but only peoples phone numbers that start with 201.


EXAMPLE:

SELECT OrgPhone#, OrgName
FROm ORG
WHERE ????????


what would I put under the WHERE





Thanks

 

[philhege]

SELECT OrgPhone#, OrgName
FROm ORG
WHERE left(orgPhone#,3) = '201'

HTH,

Phil Hegedusich
Senior Web Developer
IIMAK
<a href=&quot;

http://www.iimak.com&quot;>http://www.iimak.com</a>

-----------
Boy howdy, my Liberal Studies degree really prepared me for all of this....