File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes StartsWith function in DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "StartsWith function in DB2" Watch "StartsWith function in DB2" New topic

StartsWith function in DB2

Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I need to find out the first letter in a word

like in java we have if(GOD.startsWith("G"))) then....

Is there a similar function in db2
Ray Marsh
Ranch Hand

Joined: Jan 12, 2000
Posts: 458
DB2 is a database not a programming language. I'm not aware of any built in search functions. You can define a field to be a substring of another field, but I don't think that's what you are looking for.

A SQL example on an i-series machine would look like this:
SELECT * FROM library/file WHERE upper(field) like 'G%'

Note: you do not need to use "upper", but if you do make sure your search value is in upper-case or you will never select any records.

Mid-rangeze file=table, field=column, record=row
[ October 14, 2004: Message edited by: Ray Marsh ]

Anxiety does not empty tomorrow of its sorrows, but only empties today of its strength. – Charles Spurgeon
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32298

There is a substring function. This document lists string functions for different databases.

However, you should use the way Ray posted. It will perform queries faster and is more standard.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: StartsWith function in DB2
It's not a secret anymore!