def confirmation_number(cls): return func.left(cls.web_confirmation_number, func.charindex(".", cls.web_confirmation_number) - 1)
def split_number(cls): return func.right( cls.web_confirmation_number, func.len(cls.web_confirmation_number) - func.charindex(".", cls.web_confirmation_number), )