• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

Search for record data with special char "

hi,
in vb5.0, i tried few attempts like:
.FindNext "Stk_code Like '*"*' "
.FindNext 'Stk_code Like "*"*" ' etc..

Is there a way to search for " (and any special chars) ?
Thanks,
Collin
0
collinng
Asked:
collinng
1 Solution
 
jbilCommented:
Inclose special chars in brackets
FindNext "Stk_code Like " & ["]* & "
0
 
collinngAuthor Commented:
jbil, thanks for your reply.
i tried:
FindNext "Stk_code Like " & ["]* & "
FindNext "Stk_code Like '&["]*&'  "

however, the system takes the 2nd " as the closing inverted comma, and gives an error message refering to ] as being invalid.

Do your have alternative solution ?

Collin

0
 
uilleannCommented:
depending on your codetabel try

var = "*" & Chr(34) & "*"

FindNext "Stk_code Like " & var

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now