Hi,
I would like to select the specific string from the field(Text_Loginame) value from a table.
Below are the two records in that filed.
Text_Loginame
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided.[CLIENT: XXXXX]
Login failed for user 'ABC\XXXX'. Reason: Failed to open the explicitly specified database 'TEST'. [CLIENT: XXXXX]
The select result should be like below.
Text_Loginname
NT AUTHORITY\ANONYMOUS LOGON
ABC\XXXX
Thanks.