using & in reporting services

Last Post 22 Nov 2006 09:05 AM by ChabotWVU. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
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.
You are not authorized to post a reply.

Acceptable Use Policy