HomeActive Query BuilderUsing filter: LIKE @ + N'%' with columns name like [Last Name]

Using filter: LIKE @ + N'%' with columns name like [Last Name]


why i can use?:

SELECT [ID Client], Name, [Last Name], Phone, Address
FROM clienttable
WHERE (Name LIKE @Name + N'%')

but i cant use

SELECT [ID Client], Name, [Last Name], Phone, Address
FROM clienttable
WHERE ([Last Name] LIKE @[Last Name] + N'%')

any help will be appreciated...
thnx
Raul | email
April 24 2009, 05:50 PM
Dear Raul,

This bug is already fixed in the latest version.
Please download the updated build.
Eugene Starkov | email
2 weeks, 3 days since original post
This topic is closed