17 kensington st | east perth | wa 6004 | Australia | w printforce.com.au | e rsingh@printforce.com.au 24 SelectSalesRep1Photo If NOT EXISTS (Select 'Root\RayWhite\$AccountId$\SalesRepPhotos\'+ convert (varchar(max),id) + '' FROM sales_team WHERE client_id=$AccountId$ AND name='$SelectSalesRep1$') select 'Root\RayWhite\$AccountId$\SalesRepPhotos' ELSE Select 'Root\RayWhite\$AccountId$\SalesRepPhotos\'+ convert (varchar(max),id) + '' FROM sales_team WHERE client_id=$AccountId$ AND name='$SelectSalesRep1$' Client name should change after Root/ If you want text should come in lower case from database please use below statements (For lowercase) SelectSalesRep1 select distinct LOWER(name) from sales_team where client_id=$AccountId$ Sales Rep1 Name select '$SelectSalesRep1$' Col1 Sales Rep1 Mobile Select Top 1 phone1 from sales_team where name='$SelectSalesRep1$' and client_id=$AccountId$ Sales Rep1 Email Select Top 1 LOWER (email) from sales_team where name='$SelectSalesRep1$' and client_id=$AccountId$ Sales Rep 1 Title Select Top 1 LOWER (position) from sales_team where name='$SelectSalesRep1$' and client_id=$AccountId$ Office select LOWER(lastName) from subdealer,dealer where ExtAccountId='$AccountId$' and subdealer.dealerid=dealer.dealerid and subdealer.subdealerid=0 Website select LOWER(url) from dealer where ExtAccountId='$AccountId$' Office Address select Replace(Rtrim(Lower(address1) + ', ' +
RkJQdWJsaXNoZXIy MTI3ODI1