Post reply

functions DIFFERENCE() and SOUNDEX()

  • September 9, 2005 at 9:52 am

    #165474

    Hi!

    Is there any other function that can compares two strings ? I'm using the functions DIFFERENCE() and SOUNDEX(), but they don't consider vowels, "y" and "h", and I need something that compares everything!

    thanks


    L.I. Amaury C.R.

  • September 9, 2005 at 9:54 am

    #588772

    I can suggest like and and =, but I guess you really mean functions. What do you need to do exactly?

  • September 9, 2005 at 10:06 am

    #588776

    Hi!

    I need to compare two names, the old one and the new one, so if there is a change, I have to insert a record in the AUDIT table (a kind of log) using a trigger...


    L.I. Amaury C.R.

  • September 9, 2005 at 10:10 am

    #588779

    create trigger tr_audit_u on dbo.TableName

    for update

    as

    set nocount on

    Insert into dbo.AuditTable (id, cols)

    Select i.id, d.Name from Inserted I inner join Deleted D on I.id = D.id where coalesce(i.name, '') coalesce(d.name, '')

  • September 9, 2005 at 10:13 am

    #588781

    YOU ARE VERY KIND, THANKS A LOT!


    L.I. Amaury C.R.

  • September 9, 2005 at 10:16 am

    #588783

    HTH.

Viewing 6 posts - 1 through 5 (of 5 total)

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