You will notice that that Benchling warehouse tables store positions in plates and rack container types in columns called row_index$ and column_index$. To convert these positions into the more common plate-well format you can use the function below.

concat(chr(65 + row_index$), (column_index$ + 1))


#Example SQL
SELECT plate_id$ as "Plate Id",
row_index$,
column_index$,
concat(chr(65 + row_index$), (column_index$ + 1)) as "Well Position"
FROM well
ORDER BY row_index$,column_index$


#SQL Output

Plate Id | row_index$ | column_index$ | Well Position
96Well001 | 0 | 1 | A1
96Well001 | 0 | 2 | A2
96Well001 | 0 | 3 | A3
96Well001 | 0 | 4 | A4
96Well001 | 0 | 5 | A5
96Well001 | 0 | 6 | A6

Did this answer your question?