Thread:Project:Support desk/Search function in File list doesn't work properly/reply (7)

The efficient way is to convert the database field, specially if it's part of an index, because searching for that column would use the index. If you need to convert the value for searching, then the index won't be used and the database engine would need to do a full table scan instead.