wildcard search

[questionit]

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 ???

[damonreid]

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

[JKing]

Hi there, have a look at this link to microsoft:Wildcards

[questionit]

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

[questionit]

Thanks Jking

that page was useful

Hi there, have a look at this link to microsoft:Wildcards