oh, where to start?
pl/sql only works in oracle, not msquery
and msquery isn't db2 which is the forum you asked this question in
do you have any product manuals handy for whatever database you're using? if not, you can look up the syntax in the sql reference manual on the web -- each of those three databases has online manuals
rudy