I need your help to get records from a table where a particular field end with any numbers of any digits. For make it clear lets say i have records with values 'AirShow', 'AirShow - Copy 1', 'Air Show - Copy 2', 'Airshow - Copy1 - Copy1'.
Now I need my script to return me records 'AirShow - Copy 1' and AirShow - Copy 2', but not 'AirSHow' and 'AirShow - Copy1 - Cop1'. How can I do that? I can't use like since it will return other records and I don't want to use CLR functions.