Look at replace function in BOL:

replace (column_name, '0', '') will replace all zeroes with nothing.

Julia

-----Original Message-----
From: Usman Farhat [mailto:Usman.[Email Address Removed] Thursday, June 19, 2003 1:40 AM
To: LazyDBA.com Discussion
Subject: Removing zeros


Hi Everyone,

In SQL Server if there is any function to remove leading zeros.
For example if we have expression 00765 . Function should
result in 765.

Thanks,
Usman


--------------------------------------------------------------------
NOTA CONFIDENZIALE:
Questo messaggio ed i suoi allegati sono indirizzati esclusivamente
alle persone indicate in testa e possono contenere informazioni
confidenziali. Se avete ricevuto il messaggio per sbaglio, sappiate
che qualunque utilizzo improprio del contenuto è proibito, Vi
preghiamo quindi di inoltrarlo immediatamente al mittente e di
cancellare il messaggio. Per qualsiasi informazione vi inivitiamo a
contattarci scrivendo a [Email Address Removed]

Grazie

CONFIDENTIALITY NOTICE:
This message and its attachments are addressed solely to
the persons
above and may contain confidential information. If you
have received
the message in error, be informed that any use of the
content hereof
is prohibited. Please return it immediately to the sender
and delete
the message. Should you have any questions, please contact us
by replying
to [Email Address Removed] you
--------------------------------------------------------------------

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page