SQL problem

[CrownOfHorns]

so basically ive got the following piece of SQL:

"SELECT Scales.[Scale Name], Scales.[Root Note], Scales.Notes from Scales where (InStr(Scales.Notes, Text1.Text)"

where text1 is a textbox on the form, yet it doesnt seem to register it, is there some special way to put text1.text into the InStr function?

[dev.rogee]

I don't believe an InStr function exists in SQL.

If you're looking for the value of Text1.Text in Scales.Notes, why not try:

"SELECT Scales.[Scale Name], Scales.[Root Note], Scales.Notes from Scales where Scales.Notes like '%" & Text1.Text & "%'"

?

[CrownOfHorns]

I don't believe an InStr function exists in SQL.

If you're looking for the value of Text1.Text in Scales.Notes, why not try:

"SELECT Scales.[Scale Name], Scales.[Root Note], Scales.Notes from Scales where Scales.Notes like '%" & Text1.Text & "%'"

?

aha it works a beauty! thankyou very much!

may i ask what the % denotes?

[LaVolpe]

...may i ask what the % denotes?

The % symbol is a wild card. Similar to DOS' * symbol.

[CrownOfHorns]

The % symbol is a wild card. Similar to DOS' * symbol.

ahh that makes sense, i was using * instead of %
cool thanks