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]
>
MS Sql Server LazyDBA home page