Thanks Jack - always helpful.

Cheers,

James

Hello all,

Formatting questions for VWD 2008.

How to turn 9051234567 into (905) 123-4567

L2N7L5 to L2N 7L5

So easy to do in Access and Adobe but I've hit another brick wall in SQL.:w00t:

Suggestions?

Thanks!

James

FYI, COALESCE worked perfectly - one less problem to solve!

Thanks for your patience and advice.

Happy Thanksgiving, Canadian style:)

James

Thanks for your quick reply, Jack. I will give that a shot. I'm not always good at asking the right question. In my problem query, I have...

Thanks for the info - some of the NULL fog is beginning to lift. Any hints as how to concatenate (MS SQL) a string that has some null values...