Is it possible to use the like operator like this:
if the length of my value is 5 then it must be #A##A
if the length of my value is 5 then it must be #AA##A
or do I have to walk each position and test the value to see if it Alpha or a Number?
Is it possible to use the like operator like this:
if the length of my value is 5 then it must be #A##A
if the length of my value is 5 then it must be #AA##A
or do I have to walk each position and test the value to see if it Alpha or a Number?
Subject: Like Operator
Test the length first to decide which pattern string to use in the Like statement.