Hi, I am able to create index using the following statement:
CREATE INDEX LNAME_IDX ON USERS COMPUTED BY ( LOWER(UT_LASTNAME )) but I am not able to apply COMPUTED BY when creating Primary key. Please suggest me how to apply computed by clause for Primary key creation. (some thing similar to: ALTER TABLE USERS ADD CONSTRAINT PK_USER PRIMARY KEY COMPUTED BY (lower(AGT_MLSAGENTID), AGT_MLS_CODE)) Thanks in advance, NM ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
