# Formatting option not working

**URL:** <https://forums.toadworld.com/t/formatting-option-not-working/59398>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [May 15, 2024, 12:47pm UTC](https://forums.toadworld.com/t/formatting-option-not-working/59398 "2024-05-15T12:47:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![TheInvisibleDan](https://avatars.discourse-cdn.com/v4/letter/t/b3f665/32.png) [@TheInvisibleDan](https://forums.toadworld.com/u/TheInvisibleDan)\
**Post date:** [May 15, 2024, 12:47pm UTC](https://forums.toadworld.com/t/formatting-option-not-working/59398/1 "2024-05-15T12:47:03Z")

</div>

The SQL formatter (Editor\>Format Code) will not work whenever the SQL has the below special characters required for defining data type. Trust me, I don't like that option but there's a ton of SQL views we have that uses it. This is for a SingleStore DB which uses mySQL. Here is an example of how it's used.

COALESCE(FIELD\_NAME,0):\>bigint(20) NULL) AS `NEW_FIELD_NAME`

My current option is to find all instances, insert line breaks around that portion of SQL, comment it out and then format the whole thing and go back and remove my comments.

Is there any way around this?