New to using SQL server management studio...
Just trying to filter my table results to show only records that have (deceased) in them...
So far I have
select SURNAME, count(SURNAME) from [dbo].[blahblah] group by SURNAME order by SURNAME
I would usually use TRIM/translate like the below, however it doesn't recognise these functions...
select trim(translate(cast(GUAR_PHONE as string), '0123456789', ' ')),GUAR_PHONE from atable WHERE trim(translate(cast(GUAR_PHONE as string), '0123456789', ' '))<>'' ;