This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
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 Java Interview Guide this week in the Jobs Discussion 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: 33132

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]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: StartsWith function in DB2
It's not a secret anymore!