select Id from DB where name = *

[shlusheli]

select Id from DB where name = *

does someone knows how can i select everything from a collomn and i have to write the word "where". can i do somthing like "where name = *" Please help me... it´s urgent !!! Thanx in advanced,

 

[שמוליק י.]

Use with "like *" not "= *"

 

[shlusheli]

thank you, but i got to use "where"

So, do you know an option that i can select everything ? to put a * in the sentense ? cuse i got to use the term = somthing Tank you in advanced... Eli.

 

[שמוליק י.]

sure

u mast use with WHERE but it going like that: WHERE TBL.FLD like ´ * ´​

 

[shlusheli]

Thank you... i´ll try it !