Click here to Skip to main content
15,886,763 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hi..
i have a problem for getting large data value using select query in my sql. i have large data value in that we give one space value didn't gets. how to get the value when i give the space between word to word

for example i do the task for get the value through searching.
i give the value like this "Task Type can be the following 1. Bug 2. Task Also when the user is entering the task, let us make the task type default selected to "bug" "
but in database it can be saved as
"Task Type can be the following
1. Bug
2. Task
Also when the user is entering the task, let us make the task type default selected to "bug" "
in this cases when i get the value through coding value didn't gets.. what can i do.. please help me..

Thanks in advance..
Posted

1 solution

have you tried any query for this?

Try LIKE[^] operator in your query...
 
Share this answer
 
Comments
NaniCh 5-Feb-13 2:00am    
ya i used. but i didn't get the value.. here problem is we give the value single space in getting value the value didn't gets..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900