Home Forums SQL Server 2005 T-SQL (SS2K5) Tally table ASCII validator - Anyone ever did this? RE: Tally table ASCII validator - Anyone ever did this?

  • Nice Lowell, very interesting stripping function you got there, thanks for sharing.

    I'm not sure about the "like" you have used, I use like a lot, but never used it to generate some kind of "normal expression" like you did. I will have to look more closely as what characters I need to use to ensure my data is correct.

    The thing is, yes I want to eventually strip the unwanted characters, but I need to identify them first, and having the whole string alltogether sometimes makes it hard to see characters that are not even visible to me (i.e. char(160)). We had a weird behavior when sending the information, and we need to detect them.

    I will look at the normal expression you can create with the like operator, it is probably going to help.

    Thanks again,

    Cheers,

    J-F