using & in reporting services

Last Post 22 Nov 2006 09:05 AM by ChabotWVU. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
kamirob
New Member
New Member

--
21 Nov 2006 04:13 AM
I am trying to create reports by division. The divisions with a "&" in their name do not work. Any ideas?
ChabotWVU
New Member
New Member

--
22 Nov 2006 09:05 AM
A quick way is to use the replace command in your sql query, if you want to replace the text. For example, select replace(division,'&','and') from table.


Acceptable Use Policy
---