Hello Jason, Concatatanation error. Please fix it.
 strUpdate = "update tblCustRate set dtRateFrom =" &ndateFrom&
                "dtRateTo = " &ndateUntil&
                "decHourlyRate=" &nHourlyRate

I have a question I am using this Update in ASP. Can I use this query in SQL. If I want to use this query in SQL how will I use it? Can I write inSQL same as store procedure? If Yes please write it so that I can pass in ASP. I was wondering when can we use sql statements directly in SQL and when
can we use them in ASP. Just like above example, I am using in ASP. Is there any rule to to use
SQL statements in ASP or directly.

Not sure what your requirement is. Is that you wanted to know how to execute this from your ASP page? or you want to know how to construct the query and run that in SQL query analyser?

_________________________
- Vijay G
Strive for Perfection

yes, I want to know how to construct the query in and run that in SQL query analyser. My main question is that is upon the programmers will he or she can write the SQL in ASP or in SQL analyser. Writing in ASP means we donot need to call it from SQL, but if we write in SQL analzer we need to call from SQL to ASP.

Not sure what you are trying to achieve. I hope the answer to your other post should clarify your doubt on this.

_________________________
- Vijay G
Strive for Perfection