isql query

kodavalla · #1 (**permalink**) 12-19-03, 01:14

Hi experts,

select voucherno from voucher where substr(voucherno,1,7)='1234567'

would like to know what is equivalent sybase isql query for the above sql query?

thanks in advance
Krishna

pooja · #2 (**permalink**) 12-19-03, 01:29

Quote:

Originally posted by kodavalla
Hi experts,

select voucherno from voucher where substr(voucherno,1,7)='1234567'

would like to know what is equivalent sybase isql query for the above sql query?

thanks in advance
Krishna

hi!
try this

select voucherno
from voucher
where substring(voucherno,1,7)='1234567'

--Pooja