where and Like in sql

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

hi friends
my language is Persian (IRANIAN)
i write this query in sql server 2088 :

select * from Table1 where Name Like '%unique-char%'

but result is 0 rows
please guide me for unique characters

Posted 7-Sep-11 22:26pm

vahid_erad

Updated 7-Sep-11 22:40pm

Pravin Patil, Mumbai

v2

Add a Solution

Comments

Prerak Patel 8-Sep-11 4:41am

Which unique characters?

Philippe Mori 8-Sep-11 20:40pm

Search and ordering depend on the specified character set in the database and also if comparison are case-sensitive or not.

2 solutions

Solution 1

i think your query is correct.

any do like this

select * from Table where field like '%char%'

i hope this is useful to you

Posted 7-Sep-11 22:36pm

angappans

Comments

vahid_erad 8-Sep-11 4:39am

my language is Persian , for Persian language this query not work

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Pravin Patil, Mumbai · Accepted Answer · 2011-09-07T22:40:00

First of all you need to understand the purpose of Like keyword in SQL.
LIKE keyword helps you apply wildcard search in SQL/Oracle etc. e.g. If you want to find all the students for which name starts with P then query would be :

SELECT * FROM Students WHERE Name LIKE 'P%'

You can find a lots of examples at MSDN Like Keyword[^] also at Tech on the net[^]

Coming back to your question :
From your query it is evident that you want to list all the rows for which Name contains the string "unique-char". The reason that you are getting 0 rows, is there may be no row for which name contains the string "unique-char". Try to narrow the search. e.g

select * from Table1 where Name Like 'u%'

or

select * from Table1 where Name Like '%char%'

etc.

Hope this helps you.
All the best.