select substring(CompanyName , CHARINDEX(' ',CompanyName)+1, len(CompanyName)), CompanyName from MyCustomers

where CHARINDEX(' ',substring(CompanyName, CHARINDEX(' ',CompanyName)+1, len(CompanyName)))=0

i hope this help.

select Table1.Name, Table1.Data, Table1.Amount

from Table1 inner join (

SELECT MAX([Table1].Amount) Amount, [Table1].Name

FROM Table1

GROUP BY [Table1].Name) a

on Table1.Name=a.Name and Table1.Amount=a.Amount

try like this

select *

into beta.work.dbo.Table_backup Table_backup_1

use alias for link server

goppo

romania