Total Page Preview:   000000037005

Like - Wildcard characters Search in Azure DocumentDB

In this article we will learn Like Search - wildcard charectore search - STARTSWITH or start charectore search - ENDWITH or end charectore search in azure documentdb.

Like or Wildcard charectore search:

The CONTAINS Method will Returns a Boolean indicating whether the first string expression contains the second.

Syntax

CONTAINS(<str_expr>, <str_expr>)

Example:

SELECT CONTAINS("brijesh", "h"), CONTAINS("brijesh", "p")

Result:
 
 [{"$1": true, "$2": false}]  
 
OUTPUT
 
 
Start With Search or STARTSWITH Method:
 
The STARTSWITH Method will Returns a Boolean indicating whether the first string expression starts with the second.
 

Syntax

STARTSWITH(<str_expr>, <str_expr>)

Example:

SELECT STARTSWITH("brijesh", "ri"), STARTSWITH("brijesh", "br")

Result:
 
 [{"$1": false, "$2": true}]  
 

OUTPUT

 
 
End With Search or ENDWITH Method:
 
The ENDWITH Method will Returns a Boolean indicating whether the first string expression ends with the second.
 

Syntax

ENDWITH(<str_expr>, <str_expr>)

Example:

SELECT ENDWITH("brijesh", "sh"), ENDWITH("brijesh", "es")

Result:
 
 [{"$1": true, "$2": false}]  
 

OUTPUT

 
 
 
Thanks,

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments

Levering
09-Feb-2019
That is really interesting, You are a very skilled blogger. I've joined your feed and look forward to searching for more of your magnificent post. Also, I have shared your site in my social networks
Mein
12-Nov-2019
I blog often and I genuinely thank you for your content. Your article has truly peaked my interest. I'm going to book mark your blog and keep checking for new information about once a week. I subscribed to your RSS feed too.
Beebe
12-Nov-2019
Thanks designed for sharing such a nice thought, article is pleasant, thats why i have read it entirely
Weinberg
16-Nov-2019
Appreciation to my father who stated to me about this blog, this web site is in fact amazing.
Alfred
16-Nov-2019
Hey there I am so happy I found your web site, I really found you by error, while I was researching on Askjeeve for something else, Anyhow I am here now and would just like to say cheers for a fantastic post and a all round thrilling blog (I also love the theme/design), I don't have time to read through it all at the moment but I have saved it and also added in your RSS feeds, so when I have time I will be back to read much more, Please do keep up the awesome job.
Frazer
20-Nov-2019
Hello to every one, the contents existing at this web site are in fact awesome for people knowledge, well, keep up the nice work fellows.
Nowak
21-Nov-2019
Its like you learn my thoughts! You seem to grasp a lot about this, such as you wrote the e book in it or something. I believe that you can do with some p.c. to power the message home a little bit, however instead of that, this is fantastic blog. A great read. I will certainly be back.
Wenger
22-Nov-2019
Appreciating the dedication you put into your website and detailed information you offer. It's great to come across a blog every once in a while that isn't the same unwanted rehashed information. Fantastic read! I've bookmarked your site and I'm including your RSS feeds to my Google account.
Horrell
07-Dec-2019
Very quickly this website will be famous amid all blog viewers, due to it's fastidious articles
Strack
27-Jul-2020
I like your blog site. very nice colors & theme. Did you design this website yourself or did you work with somebody to do it for you? Plz react as I'm seeking to design my own blog and wish to understand where u got this from. lots of thanks.
Strand
08-Aug-2020
Hey I am so delighted I found your site, I really found you by error, while I was searching on Yahoo for something else, Anyhow I am here now and would just like to say thanks for a incredible post and a all round enjoyable blog (I also love the theme/design), I don't have time to read it all at the minute but I have book-marked it and also included your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the awesome work.
Sceusa
15-Sep-2020
Thanks for any other informative site. The place else may I am getting that type of info written in such a perfect manner? I have a challenge that I'm just now operating on, and I've been at the look out for such information.
Selleck
29-Oct-2020
You can definitely see your expertise in the article you write. The world hopes for more passionate writers such as you who aren’t afraid to say how they believe. All the time go after your heart.
Stoker
08-Nov-2020
Right now it seems like Expression Engine is the best blogging platform available right now. (from what I've read) Is that what you are using on your blog?
Ranieri
16-Nov-2020
Awesome post.
Lathrop
20-Nov-2020
I am pleased that I detected this web blog, just the right information that I was searching for!
Carneal
29-Nov-2020
I'm very happy to discover this page. I need to to thank you for ones time just for this fantastic read! I definitedly really liked every little bit of it and I have youu bookmrked to check out new things in your blog.
FitzRoy
29-Nov-2020
Very good post! We will bbe linking to this great content oon our website.Keep up thhe great writing!
Mccombs
11-Dec-2020
This article is truly a good one it helps new internet users, who are wishing in favor of blogging.
Applegate
11-Dec-2020
Hi there to all, it's actually a good for me to pay a quick visit this website, it includes valuable Information.
Fuqua
27-Dec-2020
Thanks for sharing excellent informations. Your web site is very cool. I'm impressed by the details that you have on this website. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for extra articles. You, my pal, ROCK! I found simply the info I already searched all over the place and simply couldn't come across. What an ideal website.
Tepper
11-Jan-2021
Excellent blog here! Also your web site a lot up very fast! What host are you the usage of? Can I get your affiliate link on your host? I desire my web site loaded up as fast as yours lol
Batman
14-Jan-2021
We absolutely love your blog and find almost all of your post's to be precisely what I'm looking for. Do you offer guest writers to write content in your case? I wouldn't mind creating a post or elaborating on most of the subjects you write concerning here. Again, awesome web site!
Janzen
21-Jan-2021
I love reading a post that will make men and women think. Also, many thanks for permitting me to comment!
Mackness
28-Jan-2021
I'm not sure exactly why but this weblog is loading extremely slow for me. Is anyone else having this problem or is it a issue on my end? I'll check back later on and see if the problem still exists.
Durr
09-Feb-2021
I have been browsing on-line greater than three hours today, but I never found any fascinating article like yours. It is beautiful worth enough for me. In my opinion, if all web owners and bloggers made just right content material as you did, the net might be a lot more helpful than ever before.
Holifield
11-Feb-2021
Hello my friend! I wiah to say thqt this article is amazing, great written and come with approximately all important infos. I'd lke to peer extra posts like this .
Alarcon
04-Mar-2021
obvіously like ʏour website however you neеd to take a look at the spеlling on quite a few of your postѕ. Many of tһem are гife with spelling issues and I find іt very troᥙblesome to tell tһe truth on the other hand I will surely come back aɡaіn.
Mota
06-Mar-2021
An outstanding share! I have just forwarded this onto a friend who has been conducting a little research on this. And he actually bought me lunch due to the fact that I stumbled upon it for him... lol. So let me reword this.... Thank YOU for the meal!! But yeah, thanks for spending time to discuss this matter here on your internet site.
Childs
17-Mar-2021
- If you're the kind of person who likes to take a look at performance, then it will likely be good to talk about your first dating experience with a skilled person, be they your family member or even a close friend. This time the older woman dating a younger man, again young enough to get her son. You don't want a primary date to be generic the slightest bit, and also you'll want the topics to become interesting, but there's two that you ought to always stay away from whenever possible.
Goloubev
18-Mar-2021
Hello, every time i used to check blog posts here in the early hours in the break of day, since i like to find out more and more.
Billups
19-Mar-2021
Your way of telling all in this paragraph is truly nice, all be capable of effortlessly know it, Thanks a lot.
Mcnamee
02-Apr-2021
Hi, I think your site might be having browser compatibility issues. When I look at your blog site in Chrome, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, excellent blog!
Peyser
08-Apr-2021
If some one wishes to be updated with most up-to-date technologies then he must be go to see this site and be up to date all the time. 0mniartist asmr
Nimmo
08-Apr-2021
Hi there, You've done a fantastic job. I will definitely digg it and personally suggest to my friends. I'm confident they will be benefited from this web site. 0mniartist asmr
Delossantos
08-Apr-2021
What's up to all, the contents present at this web site are genuinely remarkable for people knowledge, well, keep up the good work fellows.
Stanley
09-Apr-2021
I every time used to read post in news papers but now as I am a user of internet therefore from now I am using net for articles, thanks to web. asmr 0mniartist
Takasuka
09-Apr-2021
Hello there! I could have sworn I've been to this site before but after checking through some of the post I realized it's new to me. Anyways, I'm definitely happy I found it and I'll be book-marking and checking back often! 0mniartist asmr
McAuley
09-Apr-2021
I do not even understand how I stopped up right here, but I assumed this submit was great. I do not understand who you might be however definitely you are going to a well-known blogger if you happen to are not already. Cheers! asmr 0mniartist
Hayman
14-Apr-2021
I seriously love your website.. Great colors & theme. Did you create this site yourself? Please reply back as I'm looking to create my very own website and want to know where you got this from or exactly what the theme is named. Many thanks!
Palmos
15-Apr-2021
Awesome article.
Houchins
25-Apr-2021
I blog often and I truly appreciate your content. This great article has truly peaked my interest. I will book mark your site and keep checking for new details about once a week. I subscribed to your Feed as well.
Nicholson
14-May-2021
Hi there! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to no back up. Do you have any solutions to prevent hackers?
Boas
16-May-2021
I have read so many content concerning the blogger lovers except this piece of writing is really a fastidious piece of writing, keep it up.
Saxon
18-May-2021
If some one wishes to be updated with hottest technologies afterward he must be pay a quick visit this web site and be up to date everyday.
Scerri
22-May-2021
This design is incredible! You certainly know how to keep a reader amused. Between your wit and your videos, I was almost moved to start my own blog (well, almost...HaHa!) Great job. I really loved what you had to say, and more than that, how you presented it. Too cool!
Shackell
19-Jun-2021
Wow that was odd. I just wrote an really long comment but after I clicked submit my comment didn't show up. Grrrr... well I'm not writing all that over again. Anyway, just wanted to say fantastic blog!
Theriot
19-Jun-2021
Good web site you have got here.. It's hard to find quality writing like yours these days. I seriously appreciate individuals like you! Take care!!
Behrend
26-Jun-2021
This is my first time go to see at here and i am truly happy to read everthing at single place.
O'Haran
07-Jul-2021
The Lightning Thief In French Literature Books You Have To Read
Cornell
22-Jul-2021
Can I simply just say what a relief to uncover someone that actually understands what they're talking about on the web. You certainly know how to bring a problem to light and make it important. More and more people ought to read this and understand this side of the story. It's surprising you're not more popular given that you certainly possess the gift.
Thrower
22-Jul-2021
Thank you for the good writeup. It actually was once a amusement account it. Look complex to more added agreeable from you! However, how could we communicate?
Stookey
25-Jul-2021
Its like you read my mind! You appear to grasp so much approximately this, such as you wrote the guide in it or something. I believe that you just can do with a few p.c. to force the message house a bit, but other than that, this is wonderful blog. A fantastic read. I'll certainly be back.
Fraley
27-Jul-2021
Excellent post. I am going through some of these issues as well..
London
27-Jul-2021
Pretty nice post. I just stumbled upon your weblog and wanted to say that I have truly enjoyed browsing your blog posts. After all I will be subscribing to your feed and I hope you write again soon!
Constance
03-Aug-2021
You really make it seem so easy with your presentation but I find this matter to be actually something that I think I would never understand. It seems too complicated and very broad for me. I'm looking forward for your next post, I will try to get the hang of it!
Austral
03-Aug-2021
Wow! Finally I got a blog from where I be capable of really obtain helpful information regarding my study and knowledge.
Dickey
08-Aug-2021
Wow, that's what I was searching for, what a information! present here at this blog, thanks admin of this website.
Cross
26-Aug-2021
Hello, after reading this amazing article i am as well cheerful to share my familiarity here with mates.
Lenihan
28-Aug-2021
What's up, after reading this amazing paragraph i am too happy to share my know-how here with colleagues.
Torrens
30-Aug-2021
An intriguing discussion is worth comment. I do think that you should publish more about this issue, it may not be a taboo subject but generally people don't discuss these issues. To the next! All the best!!
Leone
31-Aug-2021
Greetings! Very useful advice within this post! It's the little changes that produce the greatest changes. Many thanks for sharing!
Tuttle
09-Sep-2021
Greetings! I've been reading your weblog for a long time now and finally got the bravery to go ahead and give you a shout out from Dallas Tx! Just wanted to mention keep up the excellent job!
Woodard
12-Sep-2021
I constantly spent my half an hour to read this weblog's articles or reviews everyday along with a cup of coffee.