chewy
SuperNintendo Chalmers
- Local time
- Today, 22:33
- Joined
- Mar 8, 2002
- Messages
- 581
I have a sql statement. It is a phone number field. I want to if there is a 1 infront of the phone number to take it out. The phone would look like this:
1 (315) 344-3312
The statement I am using is this:
UPDATE Customers
SET Customers.Phone = (mid(Customers.Phone,2,len(Customers.Phone)-1))
WHERE ((left(Customers.Phone,1) = '1 '))
Im not sure how the mid works. ANy help would be appreciated!
1 (315) 344-3312
The statement I am using is this:
UPDATE Customers
SET Customers.Phone = (mid(Customers.Phone,2,len(Customers.Phone)-1))
WHERE ((left(Customers.Phone,1) = '1 '))
Im not sure how the mid works. ANy help would be appreciated!