Person name may have these combination in database1. firstname only2. middlename only3. lastname only4. firstname + middlename5. firstname + lastname6. middlename + lastnameAnd firstname, middlename, lastname may contain null or empty string in data. but usee want to display Fullname without spaces then how will combine all.
2007-06-28 (first published: 2006-05-15)
1,189 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 [email protected] 8 [email protected]If I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers