Using Like and SQL

[kirkm]

I have a couple of questions relating to sql.

Can you have criteria Like "b*sometext*" ?
Because I find it fails unless I use Like "*b*sometext*"

And, can you somehow have e.g. Like "*b?*sometext*" where the ? is any number ?

Thanks

 

[jdraw]

see this techrepublic article for more info.

I suggest you tell us a little more about what you are searching for.

 

[kirkm]

Thanks jdraw. Useful link. What I was attempting does work. It just didn't work to start with as I was jjoining two fields as calculated field.

 

[kirkm]

However, what if the text started with "[" and ended with "]".
because "
[*]" isn't working.

 

[arnelgp]

If you gave [ ] * in your field , you enclosed them inside []

Like "*[[*]*"

 

[kirkm]

Thanks. It's working but as I play around with variations is isn't clear what or why it works!
e.g. I don't need the first * but do need the last one. (even though "]" is the last char in the field).