For example fjama@semarchy.com. So here is username - fjama, How can I return this expression when using SQL Server?
You can use the SEMQL Expression
LEFT(Record1.CleansedEmail, CHARINDEX('@',Record1.CleansedEmail) - 1)
Subham Dixit
For example fjama@semarchy.com. So here is username - fjama, How can I return this expression when using SQL Server?
You can use the SEMQL Expression
LEFT(Record1.CleansedEmail, CHARINDEX('@',Record1.CleansedEmail) - 1)Subham Dixit
You can use the SEMQL Expression
LEFT(Record1.CleansedEmail, CHARINDEX('@',Record1.CleansedEmail) - 1)- 
										
											Extend a model with new entities or attributes
										 
- 
										
											Data types in xDM
										 
- 
										
											Effective date on entities
										 
- 
										
											Search using wild cards
										 
- 
										
											Export a model from production and import on a development environment
										 
- 
										
											"Allow Delete" vs "Allow Removal" privileges
										 
- 
										
											LOV label in Named Query
										 
- 
										
											Select location on a map and save coordinates
										 
- 
										
											Is there a way to set up a master-detail relationship on browse mode? 
										 
- 
										
											Choose Either a Stepper or A Workflow Based on The User Privileges
										 
See all 318 topics