CONVERT() problem

[mezzanine1974]

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?

[Madhivanan]

On Jul 17, 6:54*pm, mezzanine1974 <[e-mail]:

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?

Formation matters only if you want to show them in front end
application. Otherwise use

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

[mezzanine1974]

hi Madhivanan,
it is working excellent!
Thanks

[Madhivanan]

On Jul 17, 7:31*pm, mezzanine1974 <[e-mail]:

hi Madhivanan,
it is working excellent!
Thanks

You are welcome [:)]

[--CELKO--]

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).

[mezzanine1974]

You will need about a year to UN-learn ACCESS (monolithic single user

desktop design)

It sounds to me very dramatical (

[--CELKO--]

>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