A table that I am querying from has the date field in julian date format "04194". I am only wanting to pull the information from this table that is => than todays date. Maybe some of you have done this before and can give a little help in finding the best way to do this?
You could take today's date and subtract it from the first day of the year (DATEDIFF ( datepart , startdate , enddate ) ) to give you an int value for the day of the year (actually day of year -1 since 20040101 - 20040101 = 0). Then convert to a 3 character value and concatinate the two digit year to the front and ... tadaaa ... the julian date.
CREATE FUNCTION udf_JulianToGregorian(@julian char(5))
DECLARE @gregorian datetime
SELECT @gregorian =
,CASE WHEN SUBSTRING(@julian,1,2) BETWEEN '00' AND '50'
DECLARE @julian char(5)
SELECT @julian = '04194'