ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Search

 Search found 3 matches
Author Message
  Topic: CAST Function
saulgoodman

Replies: 6
Views: 3906
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon May 15, 2017 6:31 am   Subject: Re: CAST Function


Check of the LENGTH of the string once you've removed all the numeric characters from the string with TRANSLATE. If the length is 0, it was fully numeric.

Thanks a lot mate!!
IT WORKED! :cla ...
  Topic: CAST Function
saulgoodman

Replies: 6
Views: 3906
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon May 15, 2017 5:46 am   Subject: Re: CAST Function
I was thinking of using CAST function.

I'd be more inclined to use TRANSLATE.

Ok, can you please give example, how TRANSLATE can be used in my case?
Your help is appreciated.
  Topic: CAST Function
saulgoodman

Replies: 6
Views: 3906
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon May 15, 2017 5:10 am   Subject: CAST Function
Hello Folks,

I want to check in a string whether it contains all numbers or some characters.
I was thinking of using CAST function. By this, I wanted to cast the string to integer and see if we ge ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.