formatting date/time and numbers

hai there,
im new to SQL-Server. i need to know how to Format datatypes like DateTime, Number etc. is there any function like Format() as in VB?
eg: format("1","#0")=01
Please help.. urgent..

Thanks in advance,
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!