Home Forums SQL Server 2008 T-SQL (SS2K8) I need to compare and split the string and then save it in the detail_tb but dont know how ? RE: I need to compare and split the string and then save it in the detail_tb but dont know how ?

  • I've seen that thread I'm not a fan of triggers on tables (personal preference) so hardly ever use them, but that doesnt mean its a bad thing.

    It does need the +'XX' (or some other terminating character) as that was the only way I could get it to terminate the string and return the last data column.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices