date formatting

[Garima12]

I am putting following line in view:
CAST(utnam.V_SA LE.SALE_DATE AS varchar(11))
it is giving the result like Jan 26 2005
but i want results as 01/26/05, then how should I modify above line of code?
working with sql server 2005
thks

[ck9663]

I am putting following line in view:
CAST(utnam.V_SA LE.SALE_DATE AS varchar(11))
it is giving the result like Jan 26 2005
but i want results as 01/26/05, then how should I modify above line of code?
working with sql server 2005
thks

use CONVERT() instead.


-- CK