• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • 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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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