【Query Builder：Expression】Try using IsNumeric function

As the name suggests, this function determines whether the value of the field being examined is numeric or not.
### Preparing a query ###
Launch the `Query Builder` from the [Sharperlight](https://sharperlight.com/) application menu.
Create a query using the SAP Business One datamodel.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/9405207b-7746-424d-2c7f-b9fafcaa0f5e.png)
The query result looks like this.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/485c3df1-d215-dffa-9939-cba03666bf17.png)

### Add IsNumeric function ###
Right-click in the output area and select **Add Expression**.
Enter the **Output Name** and **Description** in the `General` tab and save it with the `OK` button once.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/0ac59544-1454-cdb2-fbff-0fc117845f3e.png)
At this time, since the syntax editor on the `Expression` tab is blank, it cannot be saved, so enter **0** for the time being and save it.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/9a4bfb03-56e8-085d-effd-d31576ebe11d.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/53a81220-0d14-0646-4dcd-84055fcb1fcd.png)
Open the expression again.
Find the **IsNumeric** function from the list of functions on the Expression tab, and double-click to transfer the template to the upper editor area.
First, let's target **Customer Name** as the validation target.
Specify **Boolean** for `Data Type`.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/bb8e39cd-cfb6-8eee-5d86-e095bfeada23.png)
The output column definition looks like this.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/00613d0b-c1ea-1e86-047c-3d6d8bcd05c1.png)

Open the right-click menu with the added expression selected, and select **Clone**.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/c57aba28-cd51-21fd-bf08-fa8a40b1c14f.png)
Enter a unique name.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/0255e792-a734-8026-b5a1-5b4b6971b17b.png)
It makes a clone of the selected expression.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/088e2f08-94d2-2a0a-dd44-61524611c1d6.png)
Open the cloned expression and enter the **Output Name** and **Description** on the `General` tab.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/865c4a81-6566-7efd-a406-24dc62eb0423.png)
Go to the `Expression` tab and change the function definition to look like this:
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/80e128b9-122d-c1ee-a516-c9fc69f4e631.png)
The output items are like this now.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/432632fe-588b-4502-55a7-6cab4e8c5115.png)
### Verification ###
When verifying the Customer Name, **False** is returned because it is a string, and when verifying the Document Total, **True** is returned because it is a number.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/4f56dcd5-ff52-2ce0-31b7-a05fbc71d5ed.png)

I hope this will help your work.