On Thu, Oct 6, 2011 at 3:57 PM, Richard Broersma
<richard.broersma@gmail.com> wrote:
How about: -- using 9.1
SELECT 'wallawa9kl' ~ '^.{7}\d';
or assuming that you always have 7 letters 1 digit followed by 2
letters having a fixed width of 10:
SELECT 'wallawa9kl' ~ '^[a-zA-Z]{7}\d[a-zA-Z]{2}$';
--
Regards,
Richard Broersma Jr.
I believe that would be a regular expression right? I will look that up in the manual, thank you for the succinct answer.