[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQL Question
- Subject: [sqr-users] SQL Question
- From: "Tajinder Chahal" <Tchaha@Roushind.com>
- Date: Tue, 04 Oct 2005 11:54:38 -0400
- Delivery-date: Tue, 04 Oct 2005 10:55:51 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi All,
I know this is not a SQL discussion forum but I think SQL is the base language
used for all the databases. That is why I'm posting my question here.
Which function in DB2 can I use to get the column value before it hits the
blank space.
E.g.
1. 'How are you' - I only want to display 'How'.
2. 'This is a test' - I only want to display 'This'.
Any help would be greatly appreciated.
Thanks,
Tajinder
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users