This is a simple select statement where I am trying to convert a Julian date.
Where one of the fields is zero I get this error.
My Select statement is:
select

I'm trying to figure out how to list what file group every table is in.  I
thought this query was it :
select sys.tables.name,sys.data_spaces.name from sys.tables,sys.data_spaces
where sys.tables.lob_data_space_id = sys.data_spaces.data_space_id order by

Hello again, ive got a table with a column that normally contains a number,
for example, 4057. But there are some that finishes with an a, for example,
4057a. I want to quit the "a" and place a "1" instead, so in the last
example, the 4057a will be a 40571.

Since Microsoft decided to not continue supporting English Query after SQL
Server 2000 what have those of you how used it replaced it with?