Interested to Buy Any Domain ? << Click Here >> for more details...
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"
- 11 Answers
- 17264 Views
- I also Faced
- E-Mail Answers
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
What are the ETL Testing Operations?
when will use SQL override in a lookup transformation?
tell me few points when u become TL
How to fine tune mappings?
what are the concerns of OLTP and DSS systems?
What is etl process? How many steps etl contains?
Explain etl?
Do we need an etl tool?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
What is the difference between round-robin partitioning and hash partitioning?
What is staging area referring to?
Explain about hash partitioning?
When do we analyze the tables?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
