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.

Report message to a moderator

Previous Topic: ANY WAY FOR TRACKING ANONYMOUS BLOCK
Next Topic: inserting rows into a table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 04 02:07:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.