CONVERT() problem

In access query, i can use following expression to show "AnyInteger"
in the format of "0000"

CStr(Format(AnyInteger,"0000"))

eg:
12 yields to 0012
8 yields to 0008

how should i use CONVERT() function in SQL SERVER to achive my goal
please?

On Jul 17, 6:54*pm, mezzanine1974 <savas_karadu...@yahoo.comwrote:
Formation matters only if you want to show them in front end
application. Otherwise use

Select right('0000'+cast(anyinteger as varchar(4)),4)

hi Madhivanan,
it is working excellent!
Thanks

On Jul 17, 7:31*pm, mezzanine1974 <savas_karadu...@yahoo.comwrote:
You are welcome [:)]

In a tiered architecture, formatting and display are done in the front
end and not the database.

You will need about a year to UN-learn ACCESS (monolithic single user
desktop design) and start writing SQL (tiered, multi-user, client
server).

You will need about a year to UN-learn ACCESS (monolithic single userIt sounds to me very dramatical (

>It sounds to me very dramatic <<

No, that estimate of a year of un-learning is based on being involved
with the ANSI/ISO Standards, teaching SQL and RDBMS for a few decades,
and writing eight books on the topic.

"Perfecting oneself is as much unlearning as it is learning." --
Edsger Dijkstra