yah, noticed that too but this db im working on is part of a package that was bought and maybe they were not careful enough to check on reserved words...

thanks for the tip man.. im a bit rusty with my sql but its still there.. 😎

man oh man! 😀 i managed to run the query and get some results, just need to tweak it again for fine-tuning..

below is the corrected query

select j.templateid as JobTemplateID,...

hello to all, i just want butt-in into this discussion thread and know how to pass a condition to a sp, the condition contains a quote as the filter expr...

hello to all, i just want butt-in into this discussion thread and know how to pass a condition to a sp, the condition contains a quote as the filter expr...

sushila,

first off, many thanx for ur time n effort in analyzing my script, had this been in pl/sql i would have completed this...