IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Replace special charater in DB2 query


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
cmsmoon

New User


Joined: 17 Jun 2010
Posts: 75
Location: Chennai

PostPosted: Mon Mar 21, 2011 4:56 pm
Reply with quote

Hi Friends,

I have table with fields..In that some field value have special charaters .I want to write aquery to disply values without special charater('/') . example

Name Address Shop_adress
raja 16/2009,east st 120/200 . West street
ravi 12/9002, best street 90/23, south street

will be selected like this

Name Address Shop_adress
raja 162009east st 120200West street
ravi 129002best street 9023south street
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Mon Mar 21, 2011 5:23 pm
Reply with quote

DB2 tables do not have fields - they have rows and columns.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replace each space in cobol string wi... COBOL Programming 3
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts RC query -Time column CA Products 3
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Query on edit primary command CLIST & REXX 5
Search our Forums:

Back to Top