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
- 16991 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
SCD2 will work on only dimension tables as well as fact Table?
What are the key benefits of ETL Testing?
Difference between flat files and relational sources?
What is fact? What are the types of facts?
When do we analyze the tables?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What is data cleaning?
what do u do when DB time takes more?in sap bi
Explain about etl data integration software?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
what is data modeling?
where we cannot use sorter Transformation. if we use then we will not get correct data?
Do we need an ETL tool? When do we go for the tools in the market?
What is full load & incremental or refresh load?
What are snapshots?
