Hi,

>I have trigger for generade order number. I want to use
>char_length(TeklifNoStr) in the if command . but it is not working.
> there is error massage is
> "Token unknown - line 30, column 9
> char_length"

...

> if char_length(TeklifNoStr) = 9 then SifirTakfiye ='0';
> if char_length(TeklifNoStr) = 8 then SifirTakfiye ='00';

IF (...expression...)


Everything for an IF should go inside parenthesis.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!