关于Oracl中sql语句的书写

[regrets]

数据库为Oracle 8i,开发环境为PB8.0
cur_num="西城-2004-08-%"
MESSAGEBOX("",cur_num)
SELECT "GZP_FIRST"."CLASS_NUMBER"
INTO:new_num
FROM "GZP_FIRST"
WHERE "GZP_FIRST"."CLASS_NUMBER" like +"'"+cur_num+"'";
当执行以上代码时系统提示非法的列名错误就在like后面。
如何解决？

[liubocy]

WHERE "GZP_FIRST"."CLASS_NUMBER" like :cur_num;

[wangxichen]

like 后面要跟“＋”吗？？

[wangxichen]

在sql server中嵌入sql语句中的变量前要有“:”，不知道Oracle中是不是也要这样

[sywen]

SELECT "GZP_FIRST"."CLASS_NUMBER"
INTO:new_num
FROM "GZP_FIRST"
WHERE "GZP_FIRST"."CLASS_NUMBER" like :cur_num;