none
How to check and verify format of data string in sql RRS feed

  • Question

  • Can someone please help me to write a SQL script to check and verify format of data string in sql. This field include data string in following format:

    ODC-2016-737-733488

    ODC = its always represent by ODC

    2016 = This 4 digits represent a year which should be >= 2000 and <= current year

    737 = just 3 digits

    733488 = just 6 digits

     

    Length of string is 16. I would greatly appreciate if any of you can help with this.

    Thanks heaps

    Sapphire


    Thursday, June 6, 2019 10:58 PM