Select * From Im_Fields Where F_LONGNAME = 'БАЗА'

SELECT CHARACTER_SET_NAME, COLLATION_NAME
FROM [Imbase_integration].INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'IM_FIELDS' and COLUMN_NAME='F_LONGNAME';

Select * From Im_Fields Where F_LONGNAME = 'БАЗА' COLLATE Cyrillic_General_CS_AS

SELECT * FROM Im_Fields WHERE F_LONGNAME = 'БАЗА' COLLATE Cyrillic_General_CI_AI;

iap
iap пропущено... По крайней мере сюда запостил всё русское Я проверил Может, в таблице хранится другое написание...

declare @field varchar(64) = (SELECT F_LONGNAME  FROM [base].[dbo].[IM_FIELDS] where F_KEY = 11)
if @field = 'БАЗА'
	print 'ok'
else
	print 'no'

if CAST(@field as varbinary) = CAST('БАЗА' as varbinary)

Select * From [base].[dbo].[IM_FIELDS] where F_LONGNAME = @field

SELECT F_LONGNAME  FROM [base].[dbo].[IM_FIELDS] where F_KEY = 11

SELECT QUOTENAME(F_LONGNAME)  FROM [base].[dbo].[IM_FIELDS] where F_KEY = 11

Select * From [base].[dbo].[IM_FIELDS] where F_LONGNAME = (SELECT T.F_LONGNAME  FROM [base].[dbo].[IM_FIELDS] T where T.F_KEY = 11)

select DATABASEPROPERTYEX('base', 'Collation')

Select * From [base].[dbo].[IM_FIELDS] where F_LONGNAME = @field

declare @field varchar(64) = (SELECT F_LONGNAME  FROM [base].[dbo].[IM_FIELDS] where F_KEY = 11)

if @field = 'БАЗА'
	print 'ok'
else
	print 'no'
Select F_KEY From [base].[dbo].[IM_FIELDS] where F_LONGNAME = @field
SET @field = 'БАЗА'
Select F_KEY From [base].[dbo].[IM_FIELDS] where F_LONGNAME = @field

Select * From Im_Fields Where F_LONGNAME = 'БАЗА'

Select * From Im_Fields Where F_LONGNAME like '%'
Select * From Im_Fields Where F_LONGNAME like 'Б%'
Select * From Im_Fields Where F_LONGNAME like 'б%'
Select * From Im_Fields Where F_LONGNAME like 'БА%'
Select * From Im_Fields Where F_LONGNAME like 'Ба%'
Select * From Im_Fields Where F_LONGNAME like 'бА%'
Select * From Im_Fields Where F_LONGNAME like 'ба%'

Select * From [Imbase_integration].[dbo].[IM_FIELDS] Where F_LONGNAME = Convert(VarChar,'БАЗА')
или
Select * From [Imbase_integration].[dbo].[IM_FIELDS] Where F_LONGNAME = N'БАЗА'

Select * From [Imbase_integration].[dbo].[IM_FIELDS] Where F_LONGNAME = N'БАЗА'

Select * From [Imbase_integration].[dbo].[IM_FIELDS] Where F_LONGNAME = Convert(VarChar,'БАЗА')