select Replace('Reddyvaraprasad','vara','vara

Suppose take my name "Reddyvaraprasad"

From source it is coming Reddy vara prasad

Need to get As Reddyvara prasad/

Question Posted / ambi

Answer Posted / ambi

select Replace('Reddyvaraprasad','vara','vara ')

Is This Answer Correct ?

5 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How will you move hashed file from one location to another location?

2092

What is the roundrobin collector?

1038

How do you register plug-ins?

920

What are the steps required to kill the job in Datastage?

1148

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2405

How many types of hash files are there?

1117

What are routines in datastage? Enlist various types of routines.

1047

What is datastage?

1029

What are the various kinds of containers available in datastage?

974

What are sequencers?

1057

Which commands are used to import and export the datastage jobs?

1359

Define project in datastage?

1051

What is the importance of the exception activity in datastage?

1014

What are the difference types of stages?

1134

If you want to use a same piece of code in different jobs, how will you achieve this?

1224