Obter nome e sobrenome a partir de um campo Nome Completo (FullName)<\/p>\n\n\n\n
<\/p>\n\n\n\n
SELECT
[FullName],
CHARINDEX(‘ ‘, [FullName]),
CASE WHEN CHARINDEX(‘ ‘, [FullName]) > 0 THEN
LEFT([FullName],CHARINDEX(‘ ‘,[FullName])-1)
ELSE
[FullName]
END as FIRST_NAME,
CASE WHEN CHARINDEX(‘ ‘, [FullName]) > 0 THEN
SUBSTRING([FullName],CHARINDEX(‘ ‘,[FullName])+1, ( LEN([FullName]) – CHARINDEX(‘ ‘,[FullName])+1) )
ELSE
NULL
END as LAST_NAME
FROM TableName<\/p>\n\n\n\n
<\/p>\n\n\n\n
Exemplo de teste:<\/p>\n\n\n\n
<\/p>\n\n\n\n
Declare @temp table ( [FullName] varchar(100) )<\/p>\n\n\n\n
insert into @temp ( FullName )
VALUES ( ‘jo\u00e3o m\u00e1rio’ ), (‘jos\u00e9 souza’), (‘algu\u00e9m’)<\/p>\n\n\n\n
SELECT
[FullName],
CHARINDEX(‘ ‘, [FullName]),
CASE WHEN CHARINDEX(‘ ‘, [FullName]) > 0 THEN
LEFT([FullName],CHARINDEX(‘ ‘,[FullName])-1)
ELSE
[FullName]
END as FIRST_NAME,
CASE WHEN CHARINDEX(‘ ‘, [FullName]) > 0 THEN
SUBSTRING([FullName],CHARINDEX(‘ ‘,[FullName])+1, ( LEN([FullName]) – CHARINDEX(‘ ‘,[FullName])+1) )
ELSE
NULL
END as LAST_NAME
FROM @temp<\/p>\n","protected":false},"excerpt":{"rendered":"
Obter nome e sobrenome a partir de um campo Nome Completo (FullName)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[6,4],"tags":[41,35,5],"jetpack_publicize_connections":[],"yoast_head":"\n