INSERT & ZIP

Hi SapDB Users,

I've created a table with the following script:

	CREATE TABLE customer  
	(  
		 cno        FIXED(12,0) DEFAULT SERIAL PRIMARY KEY,  
		 title      CHAR(5),  
		 name       CHAR(10) NOT NULL,  
		 firstname  CHAR(7),  
		 zip        CHAR(5) CONSTRAINT zip like '(0-9)(0-9)(0-9)(0-9)(0-9)',  
		 city       CHAR(12) NOT NULL  
	)
 
Now I want to add a few datas into the table:

	insert into customer (title, name, firstname, zip, city) values
('Prof.','Mayer', 'Sepp', '12345', 'Erbsenstadt')

By executing this statement I just get the following error message:

	General error;300 POS(1) Integrity violation:ZIP,CUSTOMER,DBA.  
	insert into customer (title, name, firstname, zip, city) values
('Prof.','Mayer', 'Sepp', '12345', 'Erbsenstadt') 
	
My question: which is the right format for ZIP?

Thanx, Chris

------------------------------------
www.schlechte-doku-hasser.de

-- 
+++ GMX - die erste Adresse für Mail, Message, More! +++

Getestet von Stiftung Warentest: GMX FreeMail (GUT), GMX ProMail (GUT)
(Heft 9/03 - 23 e-mail-Tarife: 6 gut, 12 befriedigend, 5 ausreichend)

Jetzt selbst kostenlos testen: http://www.gmx.net