CAN ANY ONE SEND ME THE CODE FOR THE BELOW
1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD
DISPLAY OUT PUT AS "323237232"
2). NEED TO ONLY "COMPANY.COM" FROM EMAIL
FILED "TEST@COMPANY.COM"
Answer Posted / venkateswara rao
--Written in sqlserver
declare @num varchar(100) ='323-237-2323'
, @str varchar(100) ='TEST@COMPANY.COM'
, @ind int
set @ind= CHARINDEX('@',@str)
select SUBSTRING(@str,@ind+1,LEN(@str))
print @ind
select REPLACE(@num,'-','')
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do u really know that paging to disk is happening while u are using a lookup transform?
how many maximum session supports to multiload in teradata ??
what is pmrep command?
State the differences between shortcut and reusable transformation
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
Explain about power designer data modeling software?
how do u identify the changed records in operational data?
what happens if the info.server doesn't find the session parameter in the parameter file?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
what is data modeling?
What are the key benefits of ETL Testing?
Is apache nifi an etl tool?
Can we create Hierarchies in generic datasources?
what are the concerns of OLTP and DSS systems?
how do u set partition points in the mapping?