select convert(binary(n), column)
will get you a binary value (which ISQL displays as a string).
If you want that value to actually be in a string in ASE, you need to
go one step further
select bintostr(convert(binary(n),column))
1>
2>
3> create table z (a varchar(20))
4> go
1> insert z values ("abcxyz")
2> go
(1 row affected)
1> select convert(binary(20), a) from z
2> go
------------------------------------------
0x61626378797a0000000000000000000000000000
(1 row affected)
1> select bintostr(convert(binary(20), a)) from z
2> go
----------------------------------------
61626378797a0000000000000000000000000000
(1 row affected)