I have a phone number field, and I need the nxx, or the 3 numbers after the area code. How do I grab the middle part of the data in the field? I can get just the area code by using the "LEFT" command, but that doesnt work on the next 3. :(

Does your db support MID?

Cheers,

Chris

Im not sure, its a SQL 2003 server

You should be able to use SUBSTRING...
http://msdn.microsoft.com/library/de...u-sus_6btz.asp

HTH,

Chris

Cool, thank you very much :)