---

Hello,

I use a Access-db for a music-collection. Using SQL I can make

selections. I do this by using a Text-box.

The problem occurs when Text1.Text contains the character (') single

quote. Like in Sinaed O'connor or T'pau).

The code below makes clear while the problem occurs (syntax).

' ## ---
MyVar = "%" & Text1.Text & "%"

SQLstring = "SELECT * From Albums WHERE Titel LIKE '" & MyVar & "'

ORDER BY Albums.Titel ASC;"
' ## ---

What can I do? Do I have to do a searcha and replace on the

MyVar-value? If so, how? Or is there another solution.

Thanks,

Susan

---

"Susan" <ark312@home.nl> skrev i en meddelelse
news:ej9udv$tjp$1@news1.zwoll1.ov.home.nl...
> Hello,
>
> I use a Access-db for a music-collection. Using SQL I can make
>
> selections. I do this by using a Text-box.
>
> The problem occurs when Text1.Text contains the character (')
> single
>
> quote. Like in Sinaed O'connor or T'pau).
>
> The code below makes clear while the problem occurs (syntax).

SQLstring = "SELECT * From Albums WHERE Titel LIKE '[tag]' ORDER
BY Albums.Titel ASC;"
SQLString = Replace(SQLString, "[tag]", "%" & Text1.Text & "%")


--
/\ preben nielsen
\/\ prel@post.tele.dk