# Create Filter with COLLATE (I'm using SQL Server)

**URL:** <https://community.dreamfactory.com/t/create-filter-with-collate-im-using-sql-server/3820>\
**Category:** REST API\
**Tags:** rest\
**Created:** [May 11, 2017, 12:11pm UTC](https://community.dreamfactory.com/t/create-filter-with-collate-im-using-sql-server/3820 "2017-05-11T12:11:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ihor\_Byra](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/ihor_byra/32/1003_2.png) [@Ihor\_Byra](https://community.dreamfactory.com/u/Ihor_Byra)\
**Post date:** [May 11, 2017, 12:11pm UTC](https://community.dreamfactory.com/t/create-filter-with-collate-im-using-sql-server/3820/1 "2017-05-11T12:11:05Z")

</div>

Hello, I have a problem with creating search filter.

I want to create filter for the query:  
SELECT \* FROM Customer\_Extract  
WHERE Customer\_Extract.“Account ID” = ‘0013600000wXVSa’ **COLLATE SQL\_Latin1\_General\_CP1\_CS\_AS**

My Request URL without COLLATION:  
[http://104.153.59.138:8090/api/v2/asapdev1/\_table/Customer\_Extract?filter=Account%20ID%20%3D%20%20’0013600000wXVSa’](http://104.153.59.138:8090/api/v2/asapdev1/_table/Customer_Extract?filter=Account%20ID%20%3D%20%20'0013600000wXVSa')

Help me add COLLATE to filter, thank you.