good day sirs and madam,

i badly needed help.. i have this regular expression

^(?!.*--)[A-Za-z\d-]+$

it accepts alphanumeric character optionally a dash (single dash only, not consecutive dash) for exampl:

it accepts:

12a-3c-4f3fg

12ertgg2

1-2-3-3-4-3

dffgsfg

d-f-f-g-s-f-g

it does...

great thanks for the info. i have another problem. i'm trying to use a xsd validation again with regular expression, i got the regex from regexlib and it's...

using the article example.

this is empty xml (assuming it's the content of the file is coming from outside, meaning the content was read in an .xml file

DECLARE @emp AS...

declare @current_date datetime

declare @float_representation float

set @current_date = getdate() -- assuming this will return this value: 2006-09-08 10:01:03.437

-- now convert to float using cast

declare @character_representation nvarchar(100)

set @character_representation = CAST(@current_date...

so it's not possible to convert a floating point value to nvarchar????

-- this statement represent the float of the current date

SELECT CAST(CAST(getdate() AS datetime) AS float)

-- return to original date format

SELECT CAST((SELECT CAST(CAST(getdate() AS datetime) AS float)) AS datetime)

-- the reason...

that righ! i'm trying to audit all the select statement for each table, i believe trigger works only for insert, update and delete.. i'm trying to find a good...