collinng
asked on
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
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
FindNext "Stk_code Like " & ["]* & "