# select max strlen (field)

**URL:** <https://www.dynamicsuser.net/t/select-max-strlen-field/52448>\
**Category:** Developer Forum\
**Created:** [April 29, 2014, 4:19pm UTC](https://www.dynamicsuser.net/t/select-max-strlen-field/52448 "2014-04-29T16:19:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DominicB](https://avatars.discourse-cdn.com/v4/letter/d/e56c9b/32.png) [@DominicB](https://www.dynamicsuser.net/u/DominicB)\
**Post date:** [April 29, 2014, 4:19pm UTC](https://www.dynamicsuser.net/t/select-max-strlen-field/52448/1 "2014-04-29T16:19:13Z")

</div>

Is it possible to have the maximum string length of a field in a select

Something like : select maxof strlen(itemid) from inventtable

Thanks

---

<div class="post-metadata">

**Author:** ![ThomasP](https://avatars.discourse-cdn.com/v4/letter/t/ba9def/32.png) [@ThomasP](https://www.dynamicsuser.net/u/ThomasP)\
**Post date:** [April 29, 2014, 4:35pm UTC](https://www.dynamicsuser.net/t/select-max-strlen-field/52448/2 "2014-04-29T16:35:21Z")

</div>

not possible syntax error on strlen

regards,

Thomas

---

<div class="post-metadata">

**Author:** ![ThomasP](https://avatars.discourse-cdn.com/v4/letter/t/ba9def/32.png) [@ThomasP](https://www.dynamicsuser.net/u/ThomasP)\
**Post date:** [April 30, 2014, 8:02am UTC](https://www.dynamicsuser.net/t/select-max-strlen-field/52448/3 "2014-04-30T08:02:12Z")

</div>

the SQL statement is select max(len(itemid)) from inventTable

then you can try to execute through x++ with something like that

Connection Con = new Connection();  
Statement Stmt = Con.createStatement();  
ResultSet R =Stmt.executeQuery(‘select max(len(itemid)) from inventTable’);

while ( R.next() )  
{  
print R.getString(1);  
}

then you’ll probably have to manage permissions

regards,

Thomas