Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 4-Feb-13 19:05pm
NaniCh675

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

have you tried any query for this?
 
Try LIKE[^] operator in your query...
  Permalink  
Comments
NaniCh at 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)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Guruprasad.K.Basavaraju 450
1 Sergey Alexandrovich Kryukov 325
2 Shai Vashdi 318
3 OriginalGriff 265
4 Peter Leow 171
0 Sergey Alexandrovich Kryukov 9,109
1 OriginalGriff 5,290
2 Peter Leow 4,010
3 Maciej Los 3,535
4 Abhinav S 3,263


Advertise | Privacy | Mobile
Web02 | 2.8.140415.2 | Last Updated 5 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid