---
title: "Using String List in Raw SQL Step"
slug: "using-string-list-in-raw-sql-step"
updated: 2021-03-12T15:05:37Z
published: 2021-03-12T15:07:29Z
canonical: "documentation.decisions.com/using-string-list-in-raw-sql-step"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Using String List in Raw SQL Step

Example Lab ArticleWhile Example Lab projects are resources for public use, articles and assets are not actively maintained. Screenshots and features are from the specified version below. These references may become dated as new versions are released.

---

## Overview

| ## Example Lab Details |
| --- |
| **Version** | 6.5.0 |
| **Root Folder** | Example Lab - List in SQL |
| **Modules** | None |
| **Dependencies** | None |

This Example Lab demonstrates the ability for a Flow to take in a String List and Table Name in order to use the "Where In" SQL command, on the Raw SQL Step.

---

## Explanation

This Flow takes in a String List and a Table in order to use the SQL command '*Where In*' on the **Accounts** Table. This list goes through a For Each Loop were the List is converted to a properly formatted string for the **Raw SQL Command** to take.

Reference Articles

[Raw SQL Step](https://documentation.decisions.com/docs/raw-sql-step)

  

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-105.png)

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-996.png)

---

## Project Download

The examples attached were developed to be instructional and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact services@decisions.com. Import the project below to a Decisions environment on version 6.5.0 or later using our [Importing/Exporting](https://documentation.decisions.com/docs/exporting-and-importing-overview) article.  
  
  
[ExampleLab[ListInSQL].zip](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/ExampleLab%5BListInSQL%5D.zip)

---