Pomogite chainiky

DRY_GIN
Дата: 06.03.2001 09:51:39
Y menya v asp na MS Access bylo query, v kotorom tipa sortirovalis' rezyl'taty po printsipy , snachala te, v kotoryx textovoe pole sovpadaet c slovom poiska a potom vce ostal'nye
vot ya eto delo perevel v MSSQL a tam takoi fint ne proxodit
Please pomogite.
V Access rabotalo tak Select ... Where ... Order by ... , ' ' & [some_textfield] = ' slovo' desc
i tipa vce rabotalo , dazhe esli some_textfield is null
a v MS SQL rygaetsya , zamenyal = na Like - nifiga ne pomoglo ;(
chego delat' ?
P.S. ya konechno mogy na Union ALL zamenit' tipa

Select ... where .. and [some_textfield] = 'slovo' union all select .. where .. and [some_textfield] <> 'slovo'
no eto zhytko medlenno t.k. togda mne nado 8 union All t.k. v Order by eche odin parameter. ;(

P.P.S. v krainem slychae priidetsya sortirovat' po abs([Code_of_Test_Field] - code_Slova) Asc no eto kraine nezhelatel'no.


Vsem bol'shoe Cpasibo
DRY_GIN
SergSuper
Дата: 06.03.2001 11:23:05
Ну это же просто

...
order by case when [some_textfield] = ' slovo' then 0 else 1 end, ...
DRY_GIN
Дата: 06.03.2001 12:00:50
Wow
Cpasibo bol'shoe
vce zarabotalo!
sorry, chto ya takoi bezgramotnyi

DRY_GIN