SQL Error 1213

hi Guys, SELECT SPL.bulk_option FROM sys_params_link SPL, sys_var SYV WHERE SPL.value = SYV.value AND SYV.name ='DEFAULT_SYS_PARAM_OPTION'; When I run the above statement, it returns SQL error code -1213 If you do a finderr 1213 -1213 A character to numeric conversion process failed. A character value is being converted to numeric form for storage in a numeric column or variable. However, the character string cannot be interpreted as a number. It contains some characters other than white space, digits, a sign, a decimal, or the letter e; or the parts are in the wrong order, so the number cannot be deciphered. If you are using NLS, the decimal character or thousands separator might be wrong for your locale. The value column in sys_var is a char(255) and the value column in sys_params_link is an integer. It was running fine previously and now I don't what have been done wrongly. Pls help. Thanks in advance. Regards, Lee __________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

K.Hong Lee (kwonghong@yahoo.com) wrote: : hi Guys, : SELECT SPL.bulk_option : FROM sys_params_link SPL, sys_var SYV : WHERE SPL.value = SYV.value AND SYV.name = : 'DEFAULT_SYS_PARAM_OPTION'; : When I run the above statement, it returns : SQL error code -1213 DEFAULT_SYS_PARAM_OPTION is not a numeric field, quote it.