Post reply

help casting

  • March 26, 2008 at 2:45 pm

    #183643

    example:

    casting mister to Mr

  • March 26, 2008 at 3:50 pm

    #794375

    I wouldn't quite call it casting. This may help:

    DECLARE @Table TABLE (RowID int, RowValue varchar(10))

    INSERT INTO @Table

    SELECT 1, 'Mister' UNION ALL

    SELECT 2, 'Senior'

    SELECT REPLACE(RowValue,'Mister','Mr') FROM @Table

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • March 26, 2008 at 5:42 pm

    #794404

    thank you so much

Viewing 3 posts - 1 through 3 (of 3 total)

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