Greetings all. I’ve read a number of threads on using CAST and CONVERT with a SQL Server database, but I don’t believe I’ve seen the following questions.
Other than the formatting capability provided by the CONVERT function, are there any advantages or disadvantages to using one of these functions over the other? Performance differences? Any instances where you’d specifically choose one of these (aside from formatting)?
I’ve got a numeric column that I need to convert to char. Nothin’ fancy, just unformatted number to unformatted text. Which function to you suggest?
(Used to using Oracle; muddling thru SQL Server.)
Thanks,
Kathy Brown
kbrown (BOB member since 2003-01-20)