Post reply

sql query needed

  • January 3, 2012 at 9:08 am

    #1427795

    Hi

    Its really getting confuse over here... Just need to ask you need that value to be splite into two columns one with only numerical and other only alpha. Is this you want...

    Thanks & Regards
    Syed Sami Ur Rehman
    SQL-Server (Developer)
    Hyderabad
    Email-sami.sqldba@gmail.com

  • January 4, 2012 at 1:58 am

    #1428126

    There is nothing to get confused Mr Rehman...just copy paste the code before your post and you will know exactly what it does. By the way the issue is now resolved and the post before you was perfect :). Thanks anyways

  • January 4, 2012 at 3:48 am

    #1428158

    Try this

    Select convert(varchar(20),Column1)+' '+ Column2 [ColumnName]

  • January 4, 2012 at 3:50 am

    #1428159

    u r joking aint you...

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply