query of REFNO

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