Won't converting it to a string then back to an INT do it?

___________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200

-----Original Message-----
From: Coenraad Jager [mailto:[Email Address Removed]
Sent: Thursday, June 19, 2003 1:45 AM
To: LazyDBA.com Discussion
Subject: RE: Removing zeros

Hi,

Maybe you should try this:
http://www.codeproject.com/managedcpp/xpRegex.asp

From the introduction:
Regular Expressions are probably the best tool for text parsing. Using
Regular Expressions greatly simplifies anything for which you would
normally use CHARINDEX, PATINDEX, SUBSTRING, STUFF, REPLACE, etc.

Cheers, Coenraad.

> -----Original Message-----
> From: Usman Farhat [mailto:Usman.[Email Address Removed]
> Sent: donderdag 19 juni 2003 10:40
> 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]
> Thank you
> --------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
>

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