Hi, is there another way of hiding or formating column value in asterisk in select statement?
im using the command replace
SELECT REPLACE([Item].[Price],[Item].[Price], '**********') AS Price From Tablename
it works fine, but is there anyway to do this? Instead of replacing/forcing the value to display asterisk, i just need if possible the same value (of price) only masked to asterisk because i need to add the total in crystal report
You can suppress the value in Crystal so that it doesn't show up, but then include it in the totals. That's probably easier than trying to mess with your SQL so that you can get the desired data pulled into the report.