TSQL Question

microsoft.public.sqlserver.programming

4 Aug 2006 5:42 PM

Mike

Hi,

I have char field that holds a value like '001' and I need to increment
this char (like '002'). How can I do this?

Thanks

4 Aug 2006 5:59 PM

Kalen Delaney

Please do not multipost and waste the time of those answering questions.
This has been answered in .server.

--
HTH
Kalen Delaney, SQL Server MVP

Show quote

"Mike" <m***@mike.com> wrote in message
news:OnuIv0%23tGHA.2172@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> I have char field that holds a value like '001' and I need to increment
> this char (like '002'). How can I do this?
>
> Thanks
>