asked on

SyBase SQL Query Syntax

Hello Experts,

I am working with SyBase SQL Anywhere v10. I am executing this SQL statement:

select Notes from customer where custid = 100

It returns "(MEMO)"

There is long note that is stored in there. How can I view it via SQL? I believe the datatype for the column is Long Varchar.

Thanks!

pablito70

Could you, please, try this statement (not tested)

SELECT CONVERT(Notes, SQL_CHAR) AS MyNotes FROM customer WHERE custid = 100

HTH

triphen

ASKER

SELECT CONVERT(posnote, SQL_CHAR) AS MyNotes FROM member WHERE memcode = 2005

General SQL error.

[Sybase][ODBC Driver][SQL Anywhere]Syntax error near 'posnote' on line 1.

Pratima

ELECT CAST(posnote, VARCHAR(500)) AS MyNotes FROM member WHERE memcode = 2005

Pratima

ELECT CAST(posnote as VARCHAR(500)) AS MyNotes FROM member WHERE memcode = 2005

Pratima

SELECT CAST(posnote as VARCHAR(500)) AS MyNotes FROM member WHERE memcode = 2005

triphen

ASKER

SELECT CAST(posnote as VARCHAR(500)) AS MyNotes FROM member WHERE memcode = 2005

Returns "(MEMO)" as the SQL result.

Pratima

SELECT CONVERT (VARCHAR(500), posnote ) AS MyNotes FROM member WHERE memcode = 2005

OR

SELECT CONVERT (SQL_VARCHAR, posnote ) AS MyNotes FROM member WHERE memcode = 2005

triphen

ASKER

Blank Result

and

---------------------------
Adodc1
---------------------------
[Sybase][ODBC Driver][SQL Anywhere]Syntax error near 'SQL_VARCHAR' on line 1
---------------------------
OK
---------------------------

ASKER CERTIFIED SOLUTION

triphen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ganapathi

You are correct. It isn't possible.

Instead, you can alter the table to have the Notes column as "TEXT" type and Select. You will get it.

Enable SELECT INTO option by sp_dboption before running ALTER command.

triphen

ASKER

Apparently this is not possible :/