asked on SQL Omit hashes
I have a SQL view and want to omit any records with hashes in them.
E.g. ###1234156
Anyone know the syntax?
E.g. ###1234156
Anyone know the syntax?
SQL
Last Comment
HKFuey
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
That's it, thanks!
CREATE TABLE "TESTTABLE"
( "COL1" VARCHAR2(20 BYTE) ) ;
Insert into TESTTABLE (COL1) values ('###1234156');
Insert into TESTTABLE (COL1) values ('1234');
Commit;
SELECT col1
FROM testtable
WHERE INSTR(col1,'#',1)=0;
Drop table "TESTTABLE";