Adding "+" Sign...

[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!

 

[Ken Snell \(MVP\)]

Assuming that the Cellular01 field is Text:

SELECT "+" & CellularPhoneNumber As Cellular01
FROM YourTable;

 

[Charles Waters]

Assuming that the Cellular01 field is Text:

SELECT "+" & CellularPhoneNumber As Cellular01
FROM YourTable;

--

        Ken Snell
<MS ACCESS MVP>








- Show quoted text -

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

CASE CLOSED!