Sample:
sql="select * from table order by id"

How do I look at the query statement and remove all the characters
starting with "order by" and remove all remaining characters in that
line?





*** Sent via Developersdex http://www.developersdex.com ***

On Apr 19, 7:53 am, Joey Martin <j...@kytechs.comwrote:

Sample:
sql="select * from table order by id"
>
How do I look at the query statement and remove all the characters
starting with "order by" and remove all remaining characters in that
line?
>
*** Sent via Developersdexhttp://www.developersdex.com***

You could do a string search and remove everything after the word
order till you encounter the last double quote ..

Joey Martin wrote:

Sample:
sql="select * from table order by id"
>
How do I look at the query statement and remove all the characters
starting with "order by" and remove all remaining characters in that
line?
>
>

Two techniques:
1. InStr() combined with Left()

sql=Left(sql, InStr(sql,"order by") - 1)

2. Regular Expression
left as exercise for other posters

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.