Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-26-2020, 06:05 AM
eduzs eduzs is offline Like operator Windows 10 Like operator Office 2019
Expert
Like operator
 
Join Date: May 2017
Posts: 260
eduzs is on a distinguished road
Default Like operator

Is that possible to set a pattern for a single LIKE operator like ",[a-z]", so will return true when string is "," OR "a" to "z" ??? Or I should use string LIKE "," or string LIKE "[a-z]"?
Thanks
Reply With Quote
  #2  
Old 06-26-2020, 07:18 AM
eduzs eduzs is offline Like operator Windows 10 Like operator Office 2019
Expert
Like operator
 
Join Date: May 2017
Posts: 260
eduzs is on a distinguished road
Default

Sorry, so simple:
Code:
LIKE "[,a-z]"
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How's that Equation Editor inserts bullet operator instead of dot operator for multiplication? Polda18 Word 1 04-14-2019 04:23 AM
as to activate a macro without operator input ? gianca53 Excel Programming 0 02-02-2017 09:09 AM
Search folder: find addresses by OR operator samifox Outlook 0 05-05-2016 01:44 AM
Like operator Is it the PC, the monitor, or the operator? CarlT Windows 1 07-11-2014 06:09 AM
Operator symbols are not recognized by vba Sankar Tech Word VBA 12 06-18-2014 12:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft