DECLARE @FullName VARCHAR(50) = 'Mark Zuckerberg'
SELECT SUBSTRING(@FullName, 1, CHARINDEX(' ', @FullName) - 1) AS [First Name],
SUBSTRING(@FullName, CHARINDEX(' ', @FullName) + 1, LEN(@FullName)) AS [Last Name]
| Code Example |
|---|
| Sql :: |
| Sql :: |
| :: |
| Sql :: how to check table name in current database sql |
| :: |
| Sql :: distinct sql |
| Sql :: alter table myisam to innodb |
| :: |
| Sql :: |
| :: Converting mysql tables to charset utf8mb4 |
| Sql :: orcale index size |
| :: |
| Sql :: oracle list proxy users |
| :: oracle duration between timestamps |
| Sql :: update sqlite |
| Sql :: |
| :: update foreign key value in mysql |
| Sql :: postgres dump sql insert |
| :: |
| :: |
| :: |
| :: |
| Sql :: sqlite show columns |
| Sql :: sql where part of string match |
| :: sql create tabel with primary key auto_increment code |
| :: coalesce sql |
| :: |
| Sql :: how to install mysql 8.0 windows service |
| :: sql find leading space |
| Sql :: |