Home » RDBMS Server » Server Administration » Portable substrings
Portable substrings [message #370425] Thu, 23 September 1999 11:01
yirmi
Messages: 1
Registered: September 1999
Junior Member
I need a query that returns the first 16 characters of a 32 character field. The same query must run on Oracle, Informix, and SQL Server.

I tried using the substr function, but the syntax is different for each database.
Previous Topic: ANY WAY FOR TRACKING ANONYMOUS BLOCK
Next Topic: inserting rows into a table
Goto Forum:
  


Current Time: Fri Mar 29 04:53:37 CDT 2024