**YouTube** is an American [online video-sharing](https://en.wikipedia.org/wiki/Video_hosting_service "Video hosting service") [platform](https://en.wikipedia.org/wiki/Web_platform "Web platform") headquartered in [San Bruno, California](https://en.wikipedia.org/wiki/San_Bruno,_California "San Bruno, California")

cf3f59da-c081-4fab-99d2-f02e60e183b0.PNG

It’s recommended that we have a Dictionary set up for the key to act as column and value of dictionary as value match in Database.

  

Example:

Dt.Select(**\[Column1\]='value1' AND \[column2\]='value2'**)

  

The bolded text can be obtained in either AND or OR format as per requirement using the component which is obtained in String format(Data Type).

  

I/P: Dictionary values

O/P: SQL Query as String

SQL Query Builder for "OR" or "AND" Statement which can be used in select query in Database or DataTable

bf1cf625-60a3-4922-b4ca-1b51cf6ec722.JPG

e1297f59-d69a-4ab8-b06d-fa9b645f792b.JPG

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Version	Release Date	Download Link
2020.4.1	July 9, 2020
First Release
2020.4.1	July 1, 2020
First Release
2020.4.1	July 1, 2020
First Release

Xebia - SQL Query Builder