MQSeries.net :: View topic - how to find POSITION of single qoute

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to find POSITION of single qoute

how to find POSITION of single qoute

« View previous topic :: View next topic »

Author

Message

mbguy

Posted: Wed Jul 23, 2008 11:16 pm Post subject: how to find POSITION of single qoute

Apprentice

Joined: 23 Jul 2008
Posts: 25

Hi all

I want to find the position of a single qoute(') in a particular variable how do i do that
i tried doing

SET DESC_POS = POSITION(''' in DESC);
it is showing an error

i also tried like this
SET DESC_POS = POSITION("'" in DESC);
with this esql my flow is not deploying

can any one help me in this case

francoisvdm

Posted: Thu Jul 24, 2008 12:15 am Post subject:

Partisan

Joined: 09 Aug 2001
Posts: 332

This works for me:

SET i = POSITION('''' IN s); -- where '''' is 4 single quotes
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.

Francois van der Merwe

keenlearner

Posted: Thu Jul 24, 2008 2:51 am Post subject:

Acolyte

Joined: 24 Aug 2006
Posts: 62

The escape character for the esql is single quote(')
hence you need to start with ' which means you want to make string literal
then two single quotes one for escape character and once for sting literal
the end with ' which means you are ending your string literal

'''' like this

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » how to find POSITION of single qoute

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP