Post reply

inserting a value

  • May 13, 2003 at 8:55 am

    #58890

    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

    #456983

    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

    #456984

    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

    #456986

    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