If any one know about bind variable:<BR><BR>I have query where i can use bind variables and<BR>plus i also need concatination.<BR>my question is<BR>if i concatinate the query then it will no longer be able to use<BR>advantage of bind variable or it will be still there then<BR>writting a query with only concatination.<BR><BR>If anyone know the answer<BR>(I have gone thru lots of the site but every where it is either <BR>bind either concatination,not both)<BR>Thanks