Equivalent of VFP's EMPTY() function

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Equivalent of VFP's EMPTY() function

Message

From

08/08/2006 10:27:40

08/08/2006 08:15:05

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Miscellaneous

Thread ID:

01143680

Message ID:

01143782

Views:

>IF LEN(@tcSaleNo) = 0
>  -- Only spaces
>...
>
>-- If string includes numbers only
>IF CAST(@tcSaleNo AS int) = 0
>  -- Only spaces or 0's
>...

Thanks for the ideas, Sergey.

Del