select max strlen (field)

Finance and Operations/AX Developer Forum
1

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

Something like : select maxof strlen(itemid) from inventtable

Thanks

2

not possible syntax error on strlen

regards,

Thomas

3

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