# Named Query Parameter String Concat

**URL:** <https://forum.inductiveautomation.com/t/named-query-parameter-string-concat/108205>\
**Category:** Ignition\
**Tags:** database, ignition81\
**Created:** [July 7, 2025, 9:25pm UTC](https://forum.inductiveautomation.com/t/named-query-parameter-string-concat/108205 "2025-07-07T21:25:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Post date:** [July 7, 2025, 9:25pm UTC](https://forum.inductiveautomation.com/t/named-query-parameter-string-concat/108205/1 "2025-07-07T21:25:52Z")

</div>

How do I concat a parameter with a string in a named query?

For instance:

```python
SELECT 
    CONVERT(DECIMAL(18,2), vs.available_bytes / 1073741824.0) AS [Available Space (MB)]
FROM sys.master_files AS mf
CROSS APPLY sys.dm_os_volume_stats(mf.database_id, mf.file_id) AS vs
WHERE 
    DB_NAME(mf.database_id) = 'TagHistory'
    AND vs.volume_mount_point = 'F:\';

```

I want "F" to be the parameter `:disc`

---

<div class="post-metadata">

**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\
**Post date:** [July 7, 2025, 9:54pm UTC](https://forum.inductiveautomation.com/t/named-query-parameter-string-concat/108205/2 "2025-07-07T21:54:52Z")

</div>

Have you tried:

`AND vs.volume_mount_point = CONCAT(:disc, ':\');`

---

<div class="post-metadata">

**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Post date:** [July 7, 2025, 9:55pm UTC](https://forum.inductiveautomation.com/t/named-query-parameter-string-concat/108205/3 "2025-07-07T21:55:42Z")

</div>

I guess I wasn't aware of the `CONCAT` function for SQL. That would probably work