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
- 16860 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumaravelu
substr('TEST@COMPANY.COM',instr('TEST@COMPANY.COM','@')+1)
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / again kuttu!!
select substr('12132@dfsaf.com',
instr('12132@dfsaf.com', '@')+1,
length('12132@dfsaf.com'))
from dual
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / satish
select replace ('323-237-2323','-') from dual
select substr('test@company.com',6,11) from dual
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / kkr
select replace ('323-237-2323','-') from dual
select substr('abc@co.com',-7) from dual
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
Answer / bilas
use TRANSLATE function
select
translate ('323-237-2323','0123456789-', '0123456789')
from table_name;
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / erqf
2)if findc(emailid,'@','company.com')=0 then
emailid=emailid;
| Is This Answer Correct ? | 0 Yes | 3 No |
what are the reporting tools and difference between them?
What is staging area referring to?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
What is virtual Data Warehousing?
When do we go for the tools in the market?
when will use SQL override in a lookup transformation?
Explain different types of partitioning?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
what are the facilities provided by OLAP to analytical users?
what is pmrep command?
Two default user groups created in the repository are____and_____.
how do u set partition points in the mapping?
Teradata 
