I have a table that has a free form text field, however I only want to return the rows which have numeric data (e.g. 23.432, -12.432). How can I do this in SuiteQL?

It's tricky, but you might be able to use a CTE and the REGEXP_LIKE function. Something like this...

WITH TransactionTemp AS
	(
		SELECT
			TranID,
			Memo,
			CASE
				WHEN REGEXP_LIKE( Memo, '^-?[[:digit:],.]*$')
				THEN 1
				ELSE 0
  				END AS Memo_Is_Numeric
			FROM
				Transaction
			WHERE
				( Type = 'SalesOrd' )
		)
SELECT
	TranID,
	Memo
FROM
	TransactionTemp
WHERE
	( Memo_Is_Numeric = 1 )

Thanks! I figured it could be solved with regex but my regex skills are limited to copy and pasting from Stack Overflow 😆

Same here. Every single time I need a regex I have to dig for it.

Aside from being an excellent playground / tester / troubleshooting environment for regex patterns, regex101.com also provides a searchable library for all flavors of patterns

That's a great resource. Thanks!