Check in trigger

Hi there,

Can anyone tell me how to check for a string length in a trigger (BEFORE INSERT). Something like this. It should be simple but i cannot find anything about this in (online)help.

CREATE TRIGGER check_user_length FOR INLOGGEN
BEFORE INSERT AS
BEGIN
IF LENGTH(name) > 15) THEN EXCEPTION wrong_user_length;
END

Thanks!

try this :

==========================================
CREATE TRIGGER LOGGEDIN_CHECK FOR LOGGEDIN
ACTIVE BEFORE INSERT POSITION 0
AS

DECLARE VARIABLE TString VARCHAR(15);

BEGIN


BEGIN
TString = CAST(New.Name AS VARCHAR(15));
WHEN ANY DO
EXCEPTION Wrong_User_Length;

END

END ^
=========================================
Regards

Simon Wood

Thanks Simon i'll try it!