Title: sqlplus and substr command

Hi -

Can someone tell me if sqlplus functionality has changed between version 8.1.5 and 8.1.7 (on Sun Solaris)?  I have a couple of queries that used the substr function on some longer columns.  When I run it against my 8.1.5 database, the substr works fine.  It appears to be ignored when I run the same query against my 8.1.7 database.

How do I get around this?  If I define a fixed-length column, will that do it?

Thanks for any assistance you can give me -
Lisa

Reply via email to