Auer Wolfgang [EMAIL PROTECTED] stated in the list that sql studio has
to be in internal mode then exports to excel would work, I have not found
this to be the case. Any tips on how I can get a query result copied out to
an excel file?

Also, I (as well as many other peeps) need to search in Long Varchar
columns. A function similiar to MS SQL's patindex() would do nicely.

****************************************************************************
**
PATINDEX (T-SQL)
Returns the starting position of the first occurrence of a pattern in a
specified expression, or zeros if the pattern is not found, on all valid
text and character data types.

Syntax
PATINDEX('%pattern%', expression)
****************************************************************************
**


sapdb v7.0.34 (on Linux)
sql studio 7.4.3.17 (on Win2k)

thanks,

kevin

"Those who would give up essential liberty to purchase a little temporary
safety deserve neither liberty nor safety."
     -Benjamin Franklin, 1759 

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to