•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 423,335 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 5,217 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 479 | Replies: 3
 |
•
•
Join Date: Jan 2008
Location: India
Posts: 160
Reputation: 
Rep Power: 1
Solved Threads: 7
Junior Poster
hi developers,
i am developing a s/w that need a search.
i current using "like" for search.
for ex.
But this is not right way. Am i right.?
Please guide me what will be the right query for search. Can anyone guide me.
Waiting for replies. Please Help asap.
i am developing a s/w that need a search.
i current using "like" for search.
for ex.
select * from Tabl1 where col1 like "% Software Developer %" And Col2 Like "% Software Developer %"
But this is not right way. Am i right.?
Please guide me what will be the right query for search. Can anyone guide me.
Waiting for replies. Please Help asap.
Accept Challenges and Enjoy Coding... :)
•
•
Join Date: Jan 2008
Location: India
Posts: 160
Reputation:
Rep Power: 1
Solved Threads: 7
Junior Poster
Hi
i have tried something..
Here it is..
Key Word
Software Engineer Sql Server
Query
But some what not yet clear.
Please guide
i have tried something..
Here it is..
Key Word
Software Engineer Sql Server
Query
(JobDesc Like '%Software%'OR JobDesc Like '%Engineer%' OR JobDesc Like '%Sql%' OR JobDesc Like '%Server%' OR JOB_POSTING.KeySkill LIKE '%Software%'OR JOB_POSTING.KeySkill LIKE '%Engineer%' Or JOB_POSTING.KeySkill LIKE'%Sql%'Or JOB_POSTING.KeySkill LIKE'%Server%')
But some what not yet clear.
Please guide
Accept Challenges and Enjoy Coding... :)
•
•
Join Date: Jan 2008
Location: India
Posts: 160
Reputation:
Rep Power: 1
Solved Threads: 7
Junior Poster
hi
i did this in asp.net to create my query
this will give me some search key word in right format. then i did as ..
this is what for actualy query feed
i did this in asp.net to create my query
Dim KeyWord As String
Dim JobDesc, KeySkill As String
JobDesc = Strings.Replace(Trim(txtKeyWords.Text), " ", "%' OR JobDesc Like '%")
KeySkill = Strings.Replace(Trim(txtKeyWords.Text), " ", "%' OR JOB_POSTING.KeySkill LIKE '%")
SSql &= " where JOB_POSTING.DelFlag='N' and (JobDesc Like '%" & JobDesc & "%' OR "
SSql &= " JOB_POSTING.KeySkill LIKE '%" & KeySkill & "%') and "this is what for actualy query feed
•
•
Join Date: Apr 2008
Posts: 295
Reputation:
Rep Power: 1
Solved Threads: 41
Posting Whiz in Training
Hi sbv,
Your statement is formally correct. Only I would drop the blanks close to the wildcards %.
Hard to guide you because we don't know your table and your questions exactly.
krs,
tesu
•
•
•
•
Originally Posted by sbv 
hi developers,
i am developing a s/w that need a search.
i current using "like" for search.
for ex.
select * from Tabl1 where col1 like "% Software Developer %" And Col2 Like "% Software Developer %"
But this is not right way. Am i right.?
Please guide me what will be the right query for search. Can anyone guide me.
Waiting for replies. Please Help asap.
Your statement is formally correct. Only I would drop the blanks close to the wildcards %.
select * from Tabl1 where col1 like "%Software Developer%" And Col2 Like "%Software Developer%"
Hard to guide you because we don't know your table and your questions exactly.
krs,
tesu
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
adsense adult advertising biometrics blogging book business coding community copyright cult of the dead cow data development earth engine europe forum google hacking image recognition internet search legal malware marketing mcafee microsoft monetization msn news pagerank photo privacy publishing ratings revenue search search engine security seo sex software spyware support technical video video search web webmaster wiki yahoo
- Previous Thread: How to find and install IIS? URGENT. Pls. help.
- Next Thread: Get unique value in INNER JOIN in SQL server 2005 query
