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.com> wrote:
> 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)

hi Madhivanan,
it is working excellent!
Thanks

On Jul 17, 7:31*pm, mezzanine1974 <savas_karadu...@yahoo.com> wrote:
> hi Madhivanan,
> it is working excellent!
> Thanks


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 user
> desktop design)

It 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