search priority - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

search priority

Author

Topic

egemen_ates
Yak Posting Veteran

76 Posts

Posted - 2011-11-15 : 04:48:12

hello im searching '%ürün%' in product_detail column,

as you can see
my sql code and result

select G.SERVICE_ID,G.SERVICE_DETAIL
FROM G_SERVICE_DENEME G
WHERE G.SERVICE_DETAIL LIKE '%ürün%'

SERVICE_ID SERVICE_DETAIL

1 Ürün kargo sirasinda hasar görmüs...
2 ürün hakkinda bilgi
3 ürünler bozuk
4 ürünün bakiminin yapilmasi lazim,
5 Ürün arizali

BUT I WANT TO SEE BELOW THIS RESULT SO CAN I SEE FIRSTLY 'ürün' , later other result.

SERVICE_ID SERVICE_DETAIL

1 Ürün kargo sirasinda hasar görmüs...
2 ürün hakkinda bilgi
5 Ürün arizali
3 ürünler bozuk
4 ürünün bakiminin yapilmasi lazim,

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-11-15 : 04:54:45

ORDER BY
CASE WHEN LEFT(G.SERVICE_DETAIL,5) = 'ürün ' THEN 1 ELSE 2 END

No, you're never too old to Yak'n'Roll if you're too young to die.

egemen_ates
Yak Posting Veteran

76 Posts

Posted - 2011-11-15 : 05:02:07

quote:
Originally posted by webfred

ORDER BY
CASE WHEN LEFT(G.SERVICE_DETAIL,5) = 'ürün ' THEN 1 ELSE 2 END

No, you're never too old to Yak'n'Roll if you're too young to die.

but G.SERVICE_DETAIL COLUMN IS NTEXT DATATYPE, AND I WILL INSERT SOME DATA IN THIS TABLE,MAYBE THIS DATA CAN INCLUDE'ÜRÜN'

egemen_ates
Yak Posting Veteran

76 Posts

Posted - 2011-11-15 : 05:19:23

okay i do,but i insert one row

SERVICE_ID SERVICE_DETAIL

1 Ürün kargo sirasinda hasar görmüs...
2 ürün hakkinda bilgi
3 ürünler bozuk
4 ürünün bakiminin yapilmasi lazim,
5 Ürün arizali
6 arizali ürün

and execute this sql caommand

select G.SERVICE_DETAIL
FROM G_SERVICE_DENEME G
WHERE G.SERVICE_DETAIL LIKE '%ürün%'
ORDER BY
CASE WHEN LEFT((cast(G.SERVICE_DETAIL as nvarchar(100))),5) = 'ürün ' THEN 1 ELSE 2 END

,given this result

1 Ürün kargo sirasinda hasar görmüs...
2 ürün hakkinda bilgi
5 Ürün arizali
3 ürünler bozuk
4 ürünün bakiminin yapilmasi lazim,
6 arizali ürün

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-11-15 : 05:45:22

SELECT SERVICE_DETAIL
FROM G_SERVICE_DENEME
WHERE SERVICE_DETAIL LIKE '%Ürün%'
ORDER BY CASE
WHEN LEFT(SERVICE_DETAIL,5)='Ürün' THEN 1
WHEN SERVICE_DETAIL LIKE '%Ürün%' THEN 2
ELSE 3 END, SERVICE_DETAIL

--------------------------
http://connectsql.com/

egemen_ates
Yak Posting Veteran

76 Posts

Posted - 2011-11-15 : 06:34:27

quote:
Originally posted by lionofdezert

SELECT SERVICE_DETAIL
FROM G_SERVICE_DENEME
WHERE SERVICE_DETAIL LIKE '%Ürün%'
ORDER BY CASE
WHEN LEFT(SERVICE_DETAIL,5)='Ürün' THEN 1
WHEN SERVICE_DETAIL LIKE '%Ürün%' THEN 2
ELSE 3 END, SERVICE_DETAIL

--------------------------
http://connectsql.com/

THANK YOUU VERY MUCH!

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-11-15 : 08:01:06

welcom :)

--------------------------
http://connectsql.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources