Skip to Content
0
Jun 07, 2011 at 11:35 AM

SBO_TN

117 Views

Hi Experts...

Plz check this Sbo_TN.

*IF (@transaction_type = 'A'OR @transaction_type ='U') AND @object_type = '2'

BEGIN

If exists (SELECT T0.CardCode FROM OCRD AS T0 INNER JOIN

OCPR T1 ON T0.CardCode = T1.CardCode

WHERE (T0.CntctPrsn IS NULL OR T1.Cellolar is NULL ) AND (T0.CardCode = @list_of_cols_val_tab_del))

begin

SET @error = 111

SET @error_message = N'MUST SPECIFY CONTACT PERSON MOBILE NO.'

end

END*

This query running successfully. But I need that user can't put characters, symbols, or space in Cellolar field. It should just accept 10 numeric digits.

Plz help for same.

Regards,

Ravi