Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Rich75
Starting Member
8 Posts |
Posted - 2013-07-22 : 17:14:42
|
The SUBSTRING function returns @domain.com. I don't want any results to be displayed from my sql statement if it equals @myemail.com. I have other cases too that are not relevant to my question. I'm getting an error that says invalid syntax near < How can I fix this error? ThanksSELECT DISTINCT CASE CUST_EMLAD_TX WHEN SUBSTRING(CUST_EMLAD_TX, CHARINDEX('@',CUST_EMLAD_TX), LEN(CUST_EMLAD_TX)) <> '@myemail.com' THEN CUST_EMLAD_TX ENDFROM ... |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-07-22 : 17:25:12
|
[code]SELECT DISTINCT CASE WHEN RIGHT(CUST_EMLAD_TX, 12) <> '@myemail.com' THEN CUST_EMLAD_TX ELSE NULL ENDFROM ...[/code] Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
Rich75
Starting Member
8 Posts |
Posted - 2013-07-22 : 19:58:24
|
quote: Originally posted by SwePeso
SELECT DISTINCT CASE WHEN RIGHT(CUST_EMLAD_TX, 12) <> '@myemail.com' THEN CUST_EMLAD_TX ELSE NULL ENDFROM ... Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
I made a mistake. This works good. Thanks |
|
|
|
|
|
|
|