Vote count: 0 static data is working with filters but having problem in dynamic data filtering Any and all help is appreciated. Thanks! asked 55 secs agoVikrum Bhalla Let's block ads! بخوانید...
ادامه مطلبVote count: 0 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', ' '))'' ; asked 38 secs agoBenji Taylor Let's block ads! بخوانید...
ادامه مطلب