May 13, 2003 at 8:55 am
we have a value that is 10 digits long if you want to select it with a 4 as the first digit, making it 11 digits long how would you do it? its a string by the way, thanks.
May 13, 2003 at 9:10 am
If I understand it, you want to put a 4 at the start of the value:
select '4' + <colname>
from <table>
HTH
Jeremy
May 13, 2003 at 9:14 am
Hi, matt1,
could it be you've started two topic on this in different categories?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 13, 2003 at 9:15 am
thanks that worked, cheers
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply