Post reply

Regex in SQL

  • May 21, 2018 at 10:22 am

    #1991292

    Jeff, 
    I couldn't agree more. This is a code or process issue not a SQL issue. I have had this very argument with the person requesting this. But some people get an idea stuck in their heads and will not let go. If you do not mind. I would like to take your latest post and lay it in front of them. With a response of, see I am not the only one who think this is a fools errand. This needs to go to development.

  • May 22, 2018 at 9:09 am

    #1991427

    TollHouse - Monday, May 21, 2018 10:22 AM

    Jeff, 
    I couldn't agree more. This is a code or process issue not a SQL issue. I have had this very argument with the person requesting this. But some people get an idea stuck in their heads and will not let go. If you do not mind. I would like to take your latest post and lay it in front of them. With a response of, see I am not the only one who think this is a fools errand. This needs to go to development.

    If you still get stonewalled, it might be because in the long run, it might actually be fairly easy to do in T-SQL.   Checking a value against Luhn10 or to just validate that a character string has nothing but digits, dashes, and spaces, isn't really that challenging.   Ensuring the length of a given segment could be more interesting, but probably not inherently difficult.   And as one could certainly call it data validation, it's still viably in the realm of things SQL Server might be expected to do.   It is fairly important for folks to recognize that mobile banking involves cell phone pics taking pictures of checks, as opposed to the normal process that MICR was actually invented to help secure.  Such pictures are going to have a rather wide variety of quality, and eliminating the consumer behavior from that transaction is NEVER going to be perfect, nor is MICR recognition from such a photo ever going to be.   There are way too many different cell phones, all of which are subject to fingerprints and skin oils getting on the outer lens of the cell phone camera, and variations in camera resolution, image brightness, image focus, and a consumer capable of actually taking a decent picture..  Expecting industry to solve that problem isn't all that realistic.   Identifying errors is trivial, however, compared to correcting them.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 2 posts - 16 through 16 (of 16 total)

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