[dba-SQLServer] SQL Nightmares

John,

For those things that are a number, simply use the CONVERT
function.

Give me a little while today and I will send a function
for things like 00012th.

Robert


At 07:42 AM 3/20/2008, you wrote:
>Date: Wed, 19 Mar 2008 22:11:04 -0400
>From: "jwcolby" <jwcolby at colbyconsulting.com>
>Subject: Re: [dba-SQLServer] SQL Nightmares
>To: "'Discussion concerning MS SQL Server'"
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID: <003701c88a2f$a882f5b0$0201a8c0 at M90>
>Content-Type: text/plain;       charset="us-ascii"
>
>I don't know.  It needs to leave the trailing zeros.  IOW
>
>000120 = 120
>
>NOT 12
>
>REPLACE in VB simply replaces every occurrence of a zero, not what is needed
>here.
>
>John W. Colby