advertisement

Article:
  SQL Data Types
Subject:   query of REFNO
Date:   2008-06-16 22:59:50
From:   moin_rokon
Hi,


I have a problem for query of REFNO. Here two types of REFNO.1st 12 length & 2nd 16 length. How can I filter two types refno different with SQL command?
Thank you
Moin



REFNO
200031666001
200652840001
1501200652840001
1501200653474001
1501200652840001
200652840001
1501200656382001
1501200652840001
200652840001
200661874001
1509200441723001