Here's a UDF that may be more reliable, just in case...

--================================

-- Create the function

--================================

--DROP FUNCTION dbo.fNumbersOnly

GO

CREATE FUNCTION dbo.fNumbersOnly

(

  @str varchar(50)

)

RETURNS varchar(50)

AS

BEGIN

  DECLARE @pos int

Modifying Dan's example a bit, try this:

DECLARE @vat varchar(55)

SET @vat='1233%%%456'

SET @vat = Replace(@vat, SubString(@vat, PatIndex('%[^0-9]%',@vat), 1), '')

PRINT @vat

Just a note on the code referenced above. Using SQL Server 2000 Std SP4, it doesn't work. When decrypting, the second 'PRINT' keyword becomes 'puiiT'.

Actually, you can create and use indexed views is SQL Server 2000 standard edition. However, the query optimizer must be told to use view index by using WITH (NOEXPAND) in your...

You could just apply the smallest or largest evox_id using Min() or Max(), like this:

update nimages

set nimages.evox_id = (select Min(evox_id) from vehicle_tmp v where v.vehicle_nmb = nimages.vehicle_nmb)

Does your example table name P8905.Changes_log specify that the table owner is user id P8905? If not, I certainly wouldn't use a period as part of a table name.  If...

To return values from a stored procedure, use OUTPUT parameters:

drop proc test

go

create proc test

(

  @in varchar(1)

, @out varchar(3) OUTPUT

)

as

if @in = 'y'

begin

  SET @out = 'yes'

end

if @in = 'n'

begin

  SET...

To enable or disable triggers in SQL Server 2000, use

ALTER TABLE events DISABLE TRIGGER <trigger name>

ALTER TABLE events ENABLE TRIGGER <trigger name>

<trigger name> is the name of the trigger to...

How about something like this [wow - cursors and undocumented stored procedures in one batch  ]:

SET NOCOUNT ON

CREATE TABLE #space

(

 ...

Have you read these?

http://support.microsoft.com/kb/293107

http://support.microsoft.com/?scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f307197%2fen-us%2f

The datetime data type is stored in only one format.  You can use CONVERT of CAST to display it is various formats using the SELECT statement.

To insert dates, you have...

Actually, you've got it backwards.  You should use the datetime data type in your table and convert for display purposes only.

GO

CREATE TABLE #temp (id int, dt datetime)

GO

INSERT #temp(id,...

You can read Microsoft's definition in Books Online (BOL). Select the Index tab, the type 'SQL Server'. Select architecture from the sublist.

Basically, they just say that SQL Server is a server-based RDBMS...

I think the problem is that the sqlscan tool was written prior to the release of  SP4. I just downloaded and ran it, and anything related to SP4 (build 2039)...

I use OLE DB, and use this connection string:

PROVIDER='SQLOLEDB',DATASOURCE='MyServer',PROVIDERSTRING='database=MyDatabase;App=MyApp',IntegratedSecurity='SSPI'