SQL查询:返回带有空格的名字和姓氏的更好选项?

SELECT *
FROM dbo.tblCustomers
WHERE
    TRIM(FirstName) LIKE '% %'
    OR
    TRIM(LastName) LIKE '% %'

这应该行得通,标记DBMS并检查文档的length函数是否考虑了尾随空格。我假设使用SQL server并使用datalength。

SELECT *
FROM dbo.tblCustomers
WHERE (
    FirstName LIKE '% %'
    AND DATALENGTH(TRIM(FirstName)) = DATALENGTH(FirstName)
      )
    OR
    (
    LastName LIKE '% %'
    AND DATALENGTH(TRIM(LastName)) = DATALENGTH(LastName)
      );