It's been a long time since SQLServer, but for some reason, I think that the conversion functions will only convert the datatype. I *think* you then want to use a function maybe called 'format' to actually format the string - not positive of this at all - just something to check into.

- Chris