thats what i was trying to say - normally when i write something like this i have 'col=?' but in this case the value of col1 is known in advance so 'col1=known_value'. i was wondering if i could make the statement shorter given the fact there aren't any values being passed. sorry about the poor wording of the question