By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,804 Members | 1,634 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,804 IT Pros & Developers. It's quick & easy.

wildcard search

100+
P: 553
Is there any wildcard available to compare 2 strings E.g:

California

Califarnia

and return True if both the strings are very similar like above ?

i know "*" does check only after the end or beginning of the string

but there should be a way to check full string ???
Aug 7 '07 #1
Share this Question
Share on Google+
4 Replies


damonreid
Expert 100+
P: 114
You can use # for a single character in a search or * for the rest of that string but I don't know how "like" would work in that case.

Special character a[*]a aaa
Multiple characters ab*
Single character a?a
Single digit a#a
Range of characters [a-z]
Outside a range [!a-z]
Not a digit [!0-9]
Combined a[!b-m]# An9
Aug 7 '07 #2

JKing
Expert 100+
P: 1,206
Hi there, have a look at this link to microsoft:Wildcards
Aug 7 '07 #3

100+
P: 553
Damonreid,

'?' or '#' is fine for one character but what if want to check any combinition of strings . e.g:

thompson
thomson
thampson
thamson
...
...

i need to check this because if i want to compare user inputted string with a already defined constant string, i would like to compare them because user can input the same word but there could be spelling differences !

Hi there, have a look at this link to microsoft:Wildcards
Aug 8 '07 #4

100+
P: 553
Thanks Jking

that page was useful

Hi there, have a look at this link to microsoft:Wildcards
Aug 8 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.