Select Image Field which does contain data

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

noeld SSC Guru Points: 96590 More actions · Answer 1

have you tried:

Select * from Tablename Where Substring(ImageField ,8,4) ='WAVE'

HTH

* Noel

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 2

Well, can u to a substring function for a image field? I doubt.

My Blog: http://dineshasanka.spaces.live.com/

noeld SSC Guru Points: 96590 More actions · Answer 3

Well, You shouldn't

create table mytable ( i int, dta image)

insert into myTable (i , dta) values( 1 , 'TESTING IMAGE')

select i, dta , cast(substring(dta,1,4) as char(4)) Str

from mytable

Results:

i dta Str

----------- ----------------------------- ----

1 0x54455354494E4720494D414745 TEST

(1 row(s) affected)

by the way you will have to cast the substring in my previous post

HTH

* Noel

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 4

thankx it works!!!

My Blog: http://dineshasanka.spaces.live.com/

Mike Anderson SSC Veteran Points: 248 More actions · Answer 5

Why not store the content type in a separate field? That way you are not casting on an image field. Seems faster and clearer if done that way.

Mike

rschaeferhig SSCrazy Eights Points: 8776 More actions · Answer 6

Do you store content other than WAV files in this field? If not, isn't the field NULL if there's no WAV file? If so then

Select * from tablename where imagefield is null

would seem to be the best way...