Thanks a lot Vasc!

I was trying to use CASE in select,but didnt realise this is the easier way.

Ryan,

Quick question.

Was wondering what " ' ¬' "is?

I am relatively new sql,so pardon me if it is a stupid question.

Thanks

Thanks Eone!!

You guys really helped me figure this thing out. The data I am dealing with has only 1 space,but will keep the rest of the advice in mind.

Thanks Again