Click here to Skip to main content
12,446,146 members (25,397 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-server-2000 C# SQL-Server , +
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
NaniCh745

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 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
Top Experts
Last 24hrsThis month


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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100