Link to home
Start Free TrialLog in
Avatar of jamesdean666
jamesdean666

asked on

SQL Server Illegal Characters SQL Server 2008R / ASP.NET

I am trying to search a string in a database column that contains a bracket - [.

I am not able to search for this when querying the database..

Any ideas on where to start looking, I was thinking this may be an illegal character?
ASKER CERTIFIED SOLUTION
Avatar of appari
appari
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jamesdean666
jamesdean666

ASKER

I think I need to add more detail..  This is occurring on a web form (aspx) when clicking on a button and submitting the value from a textbox into the stored procedure parameter prior to hitting the database.
Hi jamesdean666,

Could you post code for your stored procedure?
appari - my apologies for not 'getting' this sooner.. this is it.. i was up coding too late... much thanks.