Adding "+" Sign...

G

Goobz

For some reason, I can't remember to save my life how to add a "+"
sign to the beginning of a field.

I need to do a query to import information into Active Directory, and
I need to add a + sign before the Cellular01 column, so the column
changes from 44 01 2344556 to +44 01 2344556 type of thing...

Thanx!
 
K

Ken Snell \(MVP\)

Assuming that the Cellular01 field is Text:

SELECT "+" & CellularPhoneNumber As Cellular01
FROM YourTable;
 
C

Charles Waters

Assuming that the Cellular01 field is Text:

SELECT "+" & CellularPhoneNumber As Cellular01
FROM YourTable;

--

        Ken Snell
<MS ACCESS MVP>








- Show quoted text -
Click to expand...

I knew it was something stupid that I couldn't remember.. Thank you...

CASE CLOSED! :)
 
Top